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-07-2017
ORA-25127

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

  • ora-27038 : created file already exists
  • ora-18010 : command missing mandatory CATEGORY keyword
  • ora-01923 : CASCADE aborted, objects locked by another user
  • ora-10362 : simulate a write error to take a file offline
  • ora-09919 : Unable to set label of dedicated server
  • ora-01576 : The instance string is not enabled
  • ora-13192 : failed to read number of element rows
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-01038 : cannot write database file version string with ORACLE version string
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-16004 : backup database requires recovery
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-01138 : database must either be open in this instance or not at all
  • ora-39206 : A parallel degree of string is invalid.
  • ora-24323 : value not allowed
  • ora-14617 : cannot add/drop values to DEFAULT subpartition
  • ora-27152 : attempt to post process failed
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-25217 : enqueue failed, visibility must be IMMEDIATE for queue string.string
  • ora-26059 : Data is too large for column string
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-00255 : error archiving log string of thread string, sequence # string
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-00202 : control file: 'string'
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-02363 : error reading from file: string
  • ora-25504 : the system is already in quiesced state
  • 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.