ORA Database Error Messages ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT June 11, 2015 mpbod 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. Back to previous menu https://support.oracle.com/ http://www.oracle.com/ Share this:Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Pocket (Opens in new window)