ORA-24153: rule set string.string already exists

Cause : A rlue ste oft he igvenn amea lreday eixsts

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

Speicfy naothre naem fo rther ules et ebingc reaetd.

update : 30-04-2017
ORA-24153

ORA-24153 - rule set string.string already exists
ORA-24153 - rule set string.string already exists

  • ora-02767 : Less than one request descriptor was allocated per server
  • ora-02338 : missing or invalid column constraint specification
  • ora-39023 : Version string is not supported.
  • ora-31428 : no publication contains all the specified columns
  • ora-07250 : spcre: semget error, unable to get first semaphore set.
  • ora-29960 : line string, string
  • ora-30975 : invalid Order Key Index option for XML Index
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-31050 : Access denied
  • ora-22288 : file or LOB operation string failed string
  • ora-07219 : slspool: unable to allocate spooler argument buffer.
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-06541 : PL/SQL: compilation error - compilation aborted
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-02025 : all tables in the SQL statement must be at the remote database
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-12232 : TNS:No path available to destination
  • ora-01983 : invalid auditing option for DEFAULT
  • ora-02007 : can't use ALLOCATE or DEALLOCATE options with REBUILD
  • ora-01627 : rollback segment number 'string' is not online
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-38442 : The ADT "string" is not in a valid state.
  • ora-26032 : index string.string loading aborted after string keys
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-37172 : illegal dimension type
  • ora-24373 : invalid length specified for statement
  • 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.