ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT



ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT..

Answer / guest

Cause: UNRECOVERABLE was specified in a CREATE TABLE
statement without also specifying a populating subquery with
an AS clause.

Action: Do not specify UNRECOVERABLE.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-02511: Invalid data type

1 Answers  


ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

1 Answers  


TNS-00295: Navigator: Security is enabled, you cannot STOP the Navigator

1 Answers  


AMD-00107: no root level in hierarchy: "string"

1 Answers  


RMAN-06555: datafile string must be restored from backup created before string

1 Answers  






ORA-09754: sppst: invalid process number passed to sppst.

1 Answers  


ORA-30370: set operators are not supported in this context

1 Answers  


ORA-07513: sscgctl: $deq unexpected return on cancel of term. lock

1 Answers  


ORA-27069: attempt to do I/O beyond the range of the file

1 Answers  


ORA-24033: no recipients for message

1 Answers  


ORA-12335: database (link name string) is not open

1 Answers  


IMP-00014: option "string" is needed, but not present in database

1 Answers  


Categories