ORA-27431: chain string.string has a user-managed rule set

Cause : A nattepmtw a smdaet om oidf yar uel estt hta si ontm aangde yb hteS cehdlue.r

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

Mdoiyf hter uel estd iercltyu snigt h edmbsr_uel_damp akcaeg ro rcetaea ntohre hcani iwtohu tsepcfiyniga url este.

update : 26-06-2017
ORA-27431

ORA-27431 - chain string.string has a user-managed rule set
ORA-27431 - chain string.string has a user-managed rule set

  • ora-39766 : invaid stream specified for column array conversion
  • ora-20000 : %s
  • ora-04055 : Aborted: "string" formed a non-REF mutually-dependent cycle with "string".
  • ora-22872 : OID INDEX clause not allowed on tables with primary key based object identifiers
  • ora-36714 : (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
  • ora-22981 : must specify a table/view having system generated OID
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-19596 : SPFILE already included
  • ora-16595 : NetSlave process string failed to terminate
  • ora-28520 : error initializing heterogeneous data dictionary translations
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-14150 : missing SUBPARTITION keyword
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-32139 : Cannot write to the stream
  • ora-35810 : (XSINPUTERR) The command has requested more input than was supplied in the command string.
  • ora-32168 : Cannot perform operation on a null AnyData
  • ora-10636 : ROW MOVEMENT is not enabled
  • ora-01353 : existing Logminer session
  • ora-38902 : errors in array insert exceed string
  • ora-22879 : cannot use the LOB INDEX clause for partitioned tables
  • ora-01907 : TABLESPACE keyword expected
  • ora-13801 : invalid value for SQLTUNE_CATEGORY parameter
  • ora-01058 : internal New Upi interface error
  • ora-09915 : Password encryption failed.
  • ora-04034 : unable to shrink pool to specified size
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-00472 : PMON process terminated with error
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-16043 : managed recovery session canceled
  • 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.