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 : 23-05-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-39706 : schema 'string' not found
  • ora-33050 : (XSAGDNGL24) AGGMAP workspace object cannot be used to aggregate workspace object, because it is defined in a different analytic workspace.
  • ora-19607 : %s is an active control file
  • ora-12420 : required procedures and functions not in policy package "string"
  • ora-16070 : parameter string contains an invalid REGISTER attribute value
  • ora-30073 : invalid adjustment value
  • ora-31651 : communication error with master process - detaching job
  • ora-13485 : error occurred during compression or decompression: string
  • ora-16161 : Cannot mix standby and online redo log file members for group string
  • ora-10648 : Tablespace SYSAUX is not offline
  • ora-22287 : invalid or modified directory occurred during string operation
  • ora-32734 : Error occurred when sending Oradebug command to remote DIAGs
  • ora-19633 : control file record string is out of sync with recovery catalog
  • ora-01549 : tablespace not empty, use INCLUDING CONTENTS option
  • ora-26090 : row is in partial state
  • ora-13350 : two or more rings of a complex polygon touch
  • ora-24100 : error in ktz testing layer
  • ora-01642 : begin backup not needed for read only tablespace 'string'
  • ora-22601 : pickler TDS context [string] is not initialized
  • ora-08308 : sllfop: Cannot open file
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-22307 : operation must be on a user-defined type
  • ora-25245 : agent name cannot be specified if address is a single-consumer queue or an exception queue
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-01649 : operation not allowed with a backup control file
  • ora-30433 : 'string.string' is not a summary
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-30690 : timeout occurred while registering a TCP/IP connection for data traffic detection
  • ora-27068 : I/O buffer is not aligned properly
  • 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.