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-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.

1 Answers  


ORA-21701: attempt to flush objects to different servers

1 Answers  


NNO-00322: statistic counter dump interval changed to number seconds

1 Answers  


ORA-16094: database shutdown during archival operation

1 Answers  


ORA-09266: spawn: error starting an Oracle process

1 Answers  






ORA-16193: Primary and standby network encryption mismatch

1 Answers  


ORA-19679: RMAN configuration number string is outside valid range of 1 through string

1 Answers  


ORA-12002: there is no materialized view log on table "string"."string"

1 Answers  


ORA-39079: unable to enqueue message string

1 Answers  


DRG-50917: escape on at end of text query string

1 Answers  


ORA-28275: Multiple mappings for user nickname to LDAP distinguished name exist.

1 Answers  


EXP-00077: multiple output files specified for unbounded export file

1 Answers  


Categories