Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-38775: cannot disable flash recovery area - flashback
database is enabled
- 2 Answers
- 9170 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lance
shutdown database first;
startup mount exclusive;
then issue ALTER DATABASE FLASHBACK OFF
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
Cause: An attempt was made to set DB_RECOVERY_FILE_DEST to
null while flashback database was enabled. Flashback
database requires DB_RECOVERY_FILE_DEST to be set.
Action: Use the ALTER DATABASE FLASHBACK OFF statement to
disable flashback database, then disable the flash recovery
area.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
ORA-12445: cannot change HIDDEN property of column
ORA-12486: effective max labels and min labels cannot be changed
ORA-19754: error reading from change tracking file
ORA-02272: constrained column cannot be of LONG datatype
TNS-12551: TNS:missing keyword
ORA-32812: subscriber string does not exist
ORA-36682: (XSDPART20) Partition name string appears twice.
ORA-15054: disk "string" does not belong to diskgroup "string"
LSX-00250: invalid normalizedString "~S"
ORA-12583: TNS:no reader
NZE-28810: Cannot create key descriptor.
ORA-29315: tablespace 'string' has been recreated
Oracle Errors 
