Oracle DBA, How To, Error, Cause and Action

ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT


Cause:


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



Action:


Do not specify UNRECOVERABLE.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)