Oracle Database 12c New Features

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified


Cause:


RECOVERABLE was specified more than once, UNRECOVERABLE was specified more than once, or both RECOVERABLE and UNRECOVERABLE were specified in a CREATE TABLE or CREATE INDEX or ALTER INDEX REBUILD statement.



Action:


Remove all but one of the RECOVERABLE or UNRECOVERABLE clauses and reissue the statement.