ORA-01784: RECOVERABLE cannot be specified with database
media recovery disabled
- 1 Answers
- 2667 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-01258: unable to delete temporary file string
ORA-09855: removeCallback: bad message format.
ORA-12454: label string does not exist for policy string
ORA-39754: FULL PARTITIONED OUTER JOIN is not supported
DRG-11208: ORACLE_HOME is not set
ORA-39004: invalid state
ORA-15009: ASM disk "string" does not exist
ORA-22305: attribute/method/parameter "string" not found
ORA-09774: osnmui: cannot send break message
QSM-02143: SUM(expr) without COUNT(expr)
ORA-02837: Unable to unlink temporary file
PLS-00909: object string is not declared or insufficient privileges to access object string
Oracle Errors 
