ORA-01784: RECOVERABLE cannot be specified with database
media recovery disabled
- 1 Answers
- 2678 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 |
RMAN-06163: some datafiles cannot be recovered, aborting the RECOVER command
ORA-32307: must use FROM ONLY clause when referencing an object table
ORA-01769: duplicate CLUSTER option specifications
SQL*Loader-00941: Error during describe of table string
LPX-00235: invalid XML version, must be 1.0 or 2.0
QSM-00507: no dimensions could be found
EXP-00052: error on row number of partition string
IMP-00008: unrecognized statement in the export file: string
DRG-50927: parser failed on line string on column string
RMAN-06051: DELETE INPUT option not implemented yet
ORA-16730: Error executing dbms_logstdby.skip_txn procedure
ORA-16636: the object is permanently disabled
Oracle Errors 
