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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23540: Redefinition not defined or initiated

1 Answers  


ORA-25175: no PRIMARY KEY constraint found

1 Answers  


ORA-00568: Maximum number of interrupt handlers exceeded

1 Answers  


ORA-27473: argument string does not exist

1 Answers  


ORA-10578: Can not allow corruption for managed standby database recovery

1 Answers  






ORA-30466: can not find the specified workload string

1 Answers  


ORA-25954: missing primary key or unique constraint on dimension

1 Answers  


ORA-24145: evaluation context string.string already exists

1 Answers  


ORA-29383: all leaves of top-plan string must be consumer groups

1 Answers  


QSM-02149: ON COMMIT with this MV requires 9.0 compatibility or higher

1 Answers  


ORA-15006: template "string" does not exist

1 Answers  


ORA-13351: two or more rings of a complex polygon overlap

1 Answers  


Categories