ORA-24146: rule string.string already exists

Cause : Ar uel fo hteg ievnn aem laraed yeixsst

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

Sepcfiya ntohre anm efro hter uel ebign rcetae.d

update : 30-04-2017
ORA-24146

ORA-24146 - rule string.string already exists
ORA-24146 - rule string.string already exists

  • ora-31650 : timeout waiting for master process response
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-01106 : database must be closed before dismounting
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-13189 : recursive SQL parse failed
  • ora-24056 : internal inconsistency for QUEUE string and destination string
  • ora-31689 : illegal value for base worker id, string
  • ora-13350 : two or more rings of a complex polygon touch
  • ora-36280 : (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.
  • ora-37074 : (XSMCSESS02) Variable workspace object has no default aggmap.
  • ora-37182 : you may only specify one dimension to partition
  • ora-12625 : TNS:missing argument
  • ora-29914 : ODCIGETINTERFACES routine does not return required stream version
  • ora-13910 : Parameter string cannot be NULL.
  • ora-25466 : data not specified for variable name: string
  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-14002 : only one GLOBAL clause may be specified
  • ora-01654 : unable to extend index string.string by string in tablespace string
  • ora-13862 : Statistics aggregation for client identifier string is not enabled
  • ora-19161 : XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
  • ora-39085 : cannot update job string for user string
  • ora-28519 : no heterogeneous data dictionary translations available
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-24006 : cannot create QUEUE, string already exists
  • ora-01346 : LogMiner processed redo beyond specified reset log scn
  • ora-13370 : failure in applying 3D LRS functions
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • 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.