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-13425: function not implemented

1 Answers  


ORA-01619: thread string is mounted by another instance

1 Answers  


NNL-01005: UNKNOWN TYPE responses received: number

1 Answers  


ORA-16032: parameter string destination string cannot be translated

1 Answers  


ORA-24397: error occured while trying to free connections

1 Answers  


PCC-00064: All uses of a given host variable must use identical indicator variables.

1 Answers  


TNS-12228: TNS:protocol adapter not loadable

1 Answers  


ORA-25952: join index must only contain inner equi-joins

1 Answers  


ORA-25256: consumer cannot be specified with a single-consumer queue or an exception queue

1 Answers  


ORA-09310: sclgt: error freeing latch

1 Answers  


ORA-26690: datatype not supported at non-Oracle system

1 Answers  


CLSS-02203: unable to access voting device: string

1 Answers  


Categories