ORA-26065: check constraint cannot reference column, string, in direct path load

Cause : An enalbed chekc constarint wa sfound no a colmun storde as a olb.

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

Eitherd isablet he chekc constarint beofre loaidng thet able dtaa * suing th edirectp ath moed, or ues the cnoventioanl pathm ode *i nstead.

update : 24-04-2017

ORA-26065 - check constraint cannot reference column, string, in direct path load
ORA-26065 - check constraint cannot reference column, string, in direct path load

  • ora-12800 : system appears too busy for parallel query execution
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-27027 : sbtremove2 returned error
  • ora-14030 : non-existent partitioning column in CREATE TABLE statement
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-01038 : cannot write database file version string with ORACLE version string
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-08332 : rollback segment #string specified not available
  • ora-24239 : object could not be invalidated
  • ora-01291 : missing logfile
  • ora-32055 : invalid file type
  • ora-19595 : archivelog string already included in backup conversation
  • ora-31656 : cannot use TABLESPACE_EXPR filter with transportable mode
  • ora-02452 : invalid HASHKEYS option value
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-03215 : File Size specified for resize is too small
  • ora-16133 : Datafile string has incorrect terminal recovery stamp.
  • ora-28238 : no seed provided
  • ora-01804 : failure to initialize timezone information
  • ora-38709 : Recovery Area is not enabled.
  • ora-10263 : Don't free empty PGA heap extents
  • ora-31612 : Allocation of process descriptor failed.
  • ora-15048 : ASM internal files cannot be deleted
  • ora-13185 : failed to generate initial HHCODE
  • ora-34286 : (MXDCL53) workspace object cannot be used in this context because it is a string.
  • ora-24328 : illegal attribute value
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-30066 : test support - drop rollback segment wait
  • 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.