ORA-02265: cannot derive the datatype of the referencing column

Cause : hT eadatytepo fht eerefercndec lomu nsin tod fenidea sey.t

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

aMeks ru ehttat ehd tatapy efot ehr fereneec doculnmi sedifen deboferr fereneicgni .t

update : 26-06-2017
ORA-02265

ORA-02265 - cannot derive the datatype of the referencing column
ORA-02265 - cannot derive the datatype of the referencing column

  • ora-32588 : supplemental logging attribute string exists
  • ora-08001 : maximum number of sequences per session exceeded
  • ora-27070 : async read/write failed
  • ora-36630 : (XSDUNION00) An empty base dimension list was specified in the concat dimension definition.
  • ora-22160 : element at index [string] does not exist
  • ora-33060 : (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
  • ora-14085 : partitioned table cannot have column with LONG datatype
  • ora-19648 : datafile string: incremental-start SCN equals checkpoint SCN
  • ora-06951 : Operating system call error
  • ora-09845 : soacon: Archmon unable to open named pipe.
  • ora-01877 : string is too long for internal buffer
  • ora-00394 : online log reused while attempting to archive it
  • ora-38781 : cannot disable media recovery - have guaranteed restore points
  • ora-02075 : another instance changed state of transaction string
  • ora-02273 : this unique/primary key is referenced by some foreign keys
  • ora-31094 : incompatible SQL type "string" for attribute or element "string"
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-38958 : Source platform string is in different byte order than target platform string
  • ora-26576 : cannot acquire SR enqueue
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-26528 : local store callback proc phase failed for 'string.string'
  • ora-16607 : one or more databases have failed
  • ora-02091 : transaction rolled back
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-30341 : dropped level has references
  • ora-30066 : test support - drop rollback segment wait
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-13407 : invalid storage parameter
  • ora-28027 : privileged database links may be used by global users
  • 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.