Oracle Error Message
ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT
Reason for the Error
UNRECOVERABLE was specified in a CREATE TABLE statement without also specifying a populating subquery with an AS clause.
Solution
Do not specify UNRECOVERABLE.