Oracle Solution for Error ora-01781
ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT
What triggered the Error:
UNRECOVERABLE was specified in a CREATE TABLE statement without also specifying a populating subquery with an AS clause.What should we do to fix it:
Do not specify UNRECOVERABLE.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
