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-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

1 Answers  


NNL-00871: Updates refused, name is a topology name: number

1 Answers  


RMAN-08183: channel string: block restore complete, elapsed time: string

1 Answers  


LFI-00117: Unable to rename file.

1 Answers  


DRG-10760: illegal format for procedure name

1 Answers  






LRM-00112: multiple values not allowed for parameter 'string'

1 Answers  


DRG-13008: cannot remove the DEFAULT sub lexer

1 Answers  


ORA-06122: NETTCP: setup failure

1 Answers  


ORA-09200: sfccf: error creating file

1 Answers  


ORA-23359: error on creating a ddl record for a repcatlog record

1 Answers  


ORA-06309: IPA: No message queue available

1 Answers  


IMG-00706: unsupported or corrupted output format

1 Answers  


Categories