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.