How to fix the Oracle error ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE?

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

Oracle Error Description

ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

Reason for the Error ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

A statement contained both [NO]LOGGING and [UN]RECOVERABLE clauses which is disallowed.

How to fix the Error ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE ?

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

Remove one of the offending clauses. [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.