Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers  


ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string

1 Answers  


ORA-33005: (XSAGDIMBREAK) Invalid breakout for dimension workspace object.

1 Answers  


DRG-12211: section or section id string does not exist

1 Answers  


ORA-02444: Cannot resolve referenced object in referential constraints

1 Answers  






ORA-33016: (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.

1 Answers  


AMD-00108: Dimension "string" is improperly mapped; the dimension has string hierarchies mapped, but hierarchy level "string" has string columns mapped

1 Answers  


DRG-10517: index string is already valid

1 Answers  


ORA-12615: TNS:preempt error

1 Answers  


PLS-00212: could not obtain enough memory to compile CASE statement

1 Answers  


O2I-00114: Invalid HFILE file name

1 Answers  


LSX-00252: invalid union "~S"

1 Answers  






Categories