ORA-01784: RECOVERABLE cannot be specified with database
media recovery disabled



ORA-01784: RECOVERABLE cannot be specified with database media recovery disabled..

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

Post New Answer

More Oracle Errors Interview Questions

NNL-00294: No entries found

1 Answers  


ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


ORA-08452: specification of E in picture mask is unsupported

1 Answers  


DRG-11203: INSO filter not supported on this platform

1 Answers  


ORA-32591: connect string too long

1 Answers  






ORA-27489: unable to process job "string.string" from job class "string"

1 Answers  


ORA-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


ORA-39707: compatibile parameter string too high for downgrade to string

1 Answers  


ORA-14616: table is not subpartitioned by List method

1 Answers  


ORA-19599: block number string is corrupt in string string

1 Answers  


ORA-23293: Cannot rename a column which is part of a join index

1 Answers  


ORA-19011: Character string buffer too small

1 Answers  


Categories