ORA-01784: RECOVERABLE cannot be specified with database
media recovery disabled
- 1 Answers
- 2818 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A CREATE TABLE or CREATE INDEX statement specified
RECOVERABLE when the database was running in NOARCHIVELOG
mode. Since logs are not being archived, they will be
overwritten and the object being created cannot be recovered
from a backup taken before the object was created.
Action: Do not specify RECOVERABLE, or restart the database
with media recovery enabled.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-32805: identifier for string too long, maximum length is string characters
ORA-00330: archived log ends at change string, need change string
ORA-13610: The directive string does not exist for task string.
ORA-00126: connection refused; invalid duplicity
ORA-01541: system tablespace cannot be brought offline; shut down if necessary
ORA-12042: cannot alter job_queue_processes in single process mode
ORA-38446: Error with embedded ADT "string" in the attribute set.
DRG-10584: failed to string string string due to an Oracle error
ORA-16091: dependent archive log destination already archived
ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
ORA-30344: number of child cols different from number of parent level cols
SQL*Loader-00128: unable to begin a session
Oracle Errors 
