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-31163: element or attribute "string" has invalid attribute value "string" (should be "string")

1 Answers  


ORA-39951: incomplete values specified for PL/SQL warning settings

1 Answers  


SQL-02112: SELECT..INTO returns too many rows

1 Answers  


ORA-28109: the number of related policies has exceeded the limit of 16

1 Answers  


ORA-02719: osnfop: fork failed

1 Answers  






ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

1 Answers  


NNO-00706: overriding next cache checkpoint, checking in number seconds

1 Answers  


TNS-00219: Pump Strategy : string

1 Answers  


TNS-04087: Unable to shutdown atleast one of the gateways.

1 Answers  


RMAN-12018: channel string disabled, job failed on it will be run on another channel

1 Answers  


ORA-06929: CMX: error when sending ORACLE_SID

1 Answers  


IMG-00911: free basic data structure failed

1 Answers  


Categories