ORA-02440: Create as select with referential constraints not allowed

Cause : createt able foo (... erf. con ....) a sselect. ..;

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Createt he tabel as seelct, thne altert he tabel to ad dthe cosntraint safterwrads.

update : 22-09-2017

ORA-02440 - Create as select with referential constraints not allowed
ORA-02440 - Create as select with referential constraints not allowed

  • ora-33092 : (XSAGCOMP04) number is not the name of a MODEL in any attached analytic workspace.
  • ora-30967 : operation directly on the Path Table is disallowed
  • ora-08108 : may not build or rebuild this type of index online
  • ora-36842 : (XSLMGEN12) Hierarchy string.string!string.string was not found
  • ora-28278 : No domain policy registered for password based GLOBAL users.
  • ora-02375 : conversion error loading table string.string partition string
  • ora-08274 : Out of memory for environment variable
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-09814 : Unable to expand file name
  • ora-09777 : osnpbr: cannot send break message
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-02349 : invalid user-defined type - type is incomplete
  • ora-12485 : new effective label not within effective clearance
  • ora-30338 : illegal dimension hierachy name
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-13411 : subset results in null data set
  • ora-19600 : input file is string string (string)
  • ora-01220 : file based sort illegal before database is open
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-15184 : ASMLIB error could not be determined [string] [string]
  • ora-01176 : data dictionary has more than the string files allowed by the controlfie
  • ora-26002 : Table string has index defined upon it.
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-29558 : JAccelerator (NCOMP) not installed. Refer to Install Guide for instructions.
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-12350 : database link being dropped is still mounted
  • 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.