ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in
this context



ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context..

Answer / guest

Cause: RECOVERABLE/UNRECOVERABLE clause is not allowed in
this context.

Action: Remove offending clause. RECOVERABLE/UNRECOVERABLE
may only be specified in CREATE TABLE/INDEX statement
describing a non-partitioned table or index and ALTER INDEX
REBUILD statement. [UN]RECOVERABLE is being deprecated in V8
and will be obsoleted in V9. To duplicate semantics of
UNRECOVERABLE clause, create an object with NOLOGGING option
and then ALTER it specifying LOGGING. To duplicate semantics
of RECOVERABLE clause, create an object with LOGGING option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-40102: invalid input string for data mining operation string

1 Answers  


ORA-07416: slpath: pathname construction failed; lack of output buffer space.

1 Answers  


LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


DRG-52201: imcompatible Oracle Text versions

1 Answers  


RMAN-06058: a current controlfile cannot be included along with a standby controlfile

1 Answers  






RMAN-20011: target database incarnation is not current in recovery catalog

1 Answers  


ORA-21612: key is already being used

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


RMAN-10035: exception raised in RPC: string

1 Answers  


RMAN-06483: changed datafile copy expired

1 Answers  


ORA-25129: cannot modify constraint (string) - no such constraint

1 Answers  


ORA-30202: NULL pointer to OCIMsgh was passed to OCIMsg function

1 Answers  


Categories