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 : 28-07-2017

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

  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-07746 : slemrd: invalid error message file handle
  • ora-01344 : LogMiner coordinator already attached
  • ora-19209 : invalid or unsupported formatting argument
  • ora-12663 : Services required by client not available on the server
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-25506 : resource manager has not been continuously on in some instances
  • ora-31018 : Error deleting XML document
  • ora-25326 : Array string operation failed for message at index string
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-13154 : invalid precision specified
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-01497 : illegal option for ANALYZE CLUSTER
  • ora-22632 : AnyDataSet parameter is not valid for the current operation
  • ora-24781 : branches don't belong to the same global transaction
  • ora-16545 : unable to get response
  • ora-23343 : no match for specified conflict resolution information
  • ora-16711 : the resource guard index is out of bounds
  • ora-02260 : table can have only one primary key
  • ora-30188 : reserved for future use
  • ora-29387 : no top-plans found in the pending area
  • ora-13906 : The tablepace is not of the right type.
  • ora-08182 : operation not supported while in Flashback mode
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • 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.