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

ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.

1 Answers  


PLS-00389: table, view or alias name "string" not allowed in this context

1 Answers  


ORA-00373: online log version string incompatible with ORACLE version string

1 Answers  


ORA-12424: length exceeds binary label size

1 Answers  


NNL-00570: save_config [<server_list>] : saves server configuration to parameter file

1 Answers  






ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

1 Answers  


RMAN-06719: file "string" (string bytes) restrieved from catalog

1 Answers  


PCC-02316: illegal operator in constant expression

1 Answers  


NZE-28874: SSL: I/O closed - override goodbye kiss

1 Answers  


ORA-27076: unable to set limit for open files

1 Answers  


ORA-31421: change table does not exist

1 Answers  


ORA-32034: unsupported use of WITH clause

1 Answers  


Categories