Thursday 15 March 2012

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

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

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

Action: Remove offending clause. RECOVERABLE or UNRECOVERABLE may only be specified in CREATE TABLE or 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.

No comments:

Post a Comment