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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Do not specify UNRECOVERABLE.

update : 28-07-2017
ORA-01781

ORA-01781 - UNRECOVERABLE cannot be specified without AS SELECT
ORA-01781 - UNRECOVERABLE cannot be specified without AS SELECT

  • ora-31636 : session is already attached to job string for user string
  • ora-12154 : TNS:could not resolve the connect identifier specified
  • ora-37107 : (XSVPART07) Attempt to write to non-existent partition of workspace object.
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-10931 : trace name context forever
  • ora-19585 : premature end of volume on piece string
  • ora-01291 : missing logfile
  • ora-13373 : invalid line segment in geodetic data
  • ora-09212 : sfwfbmt: error writing to file
  • ora-30114 : error when processing from command line
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • ora-32054 : lost communication with FMPUTL process
  • ora-29802 : missing CONTEXT keyword
  • ora-39301 : schema "string" does not exist or is in use
  • ora-23378 : connection qualifier "string" is not valid for object group "string"."string"
  • ora-25409 : failover happened during the network operation,cannot continue
  • ora-29851 : cannot build a domain index on more than one column
  • ora-09940 : ORACLE password file header is corrupt
  • ora-00820 : Specified value of sga_max_size is too small, needs to be at least stringM
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-01505 : error in adding log files
  • ora-08312 : sllfop: unrecognized processing option
  • ora-19707 : invalid record block number - string
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-28527 : Heterogeneous Services datatype mapping error
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-01192 : must have at least one enabled thread
  • ora-22608 : cannot add an attribute to the already generated image handle
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.