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-38441: System could not derive the list of STORED and INDEXED attributes.

1 Answers  


TNS-01102: TNS application contacted was not the listener

1 Answers  


ORA-29900: operator binding does not exist

1 Answers  


TNS-02021: DIRECT_HANDOFF can be either ON or OFF.

1 Answers  


LPX-00110: invalid ~1s "~2S" (not a Name)

1 Answers  






ORA-16004: backup database requires recovery

1 Answers  


ORA-12204: TNS:received data refused from an application

1 Answers  


NNL-00221: Statistic counter logging interval is now string

1 Answers  


ORA-14189: this physical attribute may not be specified for an index subpartition

1 Answers  


SQL*Loader-00623: second enclosure string not present

1 Answers  


DRG-10826: no document with the specified textkey is found

1 Answers  


ORA-19579: archivelog record for string not found

1 Answers  


Categories