How to fix the Oracle error ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices?

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

Oracle Error Description

ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

Reason for the Error ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

CREATE TABLE/INDEX statement used to create a partitioned table/index contained RECOVERABLE or UNRECOVERABLE clause which is illegal

How to fix the Error ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices ?

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

Remove offending clause. [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.