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-07266: sppst: invalid process number passed to sppst.

1 Answers  


RMAN-07502: List of Files Unknown to the Database

1 Answers  


ORA-30348: ADD and DROP cannot both be specified

1 Answers  


ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


ORA-26502: error resignal

1 Answers  


ORA-23423: job number string is not positive

1 Answers  


ORA-38445: TOP clause not allowed with no statistics

1 Answers  


ORA-01286: start interval required

1 Answers  


ORA-24903: invalid namespace attribute passed into OCI call

1 Answers  


AMD-00106: parent string "string" must be removed before child string "string" can be removed

1 Answers  


ORA-36912: (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.

1 Answers  


ORA-37115: New OLAP API history is not allowed

1 Answers  


Categories