Oracle DB Error ORA-01783 only one RECOVERABLE or UNRECOVERABLE clause may be specified

The following is the cause of this error:

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 you can take to resolve this issue: Remove all but one of the RECOVERABLE or UNRECOVERABLE clauses and reissue the statement.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related