How to fix the Oracle error ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context?

In this post, you’ll learn more about the Oracle ErrorORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context

RECOVERABLE/UNRECOVERABLE clause is not allowed in this context.

How to fix the Error ORA-14105: RECOVERABLE/UNRECOVERABLE may not be specified in this context ?

You can fix this error in Oracle by following the below steps

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.