ORA-25127: RELY not allowed in NOT NULL constraint

Cause : A nattepmtt os e tRLEYo nf o rNTO UNL Lcnosrtanit.

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

olnyN OERL Ymya eb pseicfeidf o raN O TNLULc osntaritn.

update : 28-05-2017
ORA-25127

ORA-25127 - RELY not allowed in NOT NULL constraint
ORA-25127 - RELY not allowed in NOT NULL constraint

  • ora-09802 : Conversion of binary label to string failed.
  • ora-13632 : The user cancelled the current operation.
  • ora-39174 : Encryption password must be supplied.
  • ora-13900 : missing or invalid parameter string
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-28662 : IOT index and overflow segments must share the same LOGGING attribute
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-16057 : DGID from server not in Data Guard configuration
  • ora-01666 : control file is for a standby database
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-12709 : error while loading create database character set
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-19674 : file string is already being backed up with proxy copy
  • ora-08434 : raw data has invalid trailing sign
  • ora-15198 : operation string is not yet available
  • ora-12618 : TNS:versions are incompatible
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-39178 : cannot perform estimate on metadata only jobs
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-29502 : NAMED keyword required in CREATE JAVA RESOURCE
  • ora-29826 : keyword FOR is missing
  • ora-36714 : (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
  • ora-02825 : Request on free list was not free
  • ora-33024 : (XSAGDNGL11) AGGMAP workspace object contains duplicate information.
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • ora-19581 : no files have been named
  • ora-29523 : authorization error for unknown referenced name
  • 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.