ORA-32636: Too many rules in MODEL

Cause : The number of rules (possibly after rule unfolding) exceeded the maximum number of rules allowed.

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

Reduce the number of rules.

update : 24-06-2017

ORA-32636 - Too many rules in MODEL
ORA-32636 - Too many rules in MODEL

  • ora-00028 : your session has been killed
  • ora-19679 : RMAN configuration number string is outside valid range of 1 through string
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-30060 : Internal event for RECO tracing
  • ora-02853 : Invalid server list latch time out value
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-25294 : Cannot propagate user buffered messages to a database with version lower than 10.2
  • ora-29531 : no method string in class string
  • ora-39060 : table(s) dropped because of conflict with master table
  • ora-31525 : could not find column string in CDC change table string.string
  • ora-30183 : invalid field width specifier
  • ora-02009 : the size specified for a file must not be zero
  • ora-19034 : Type not supported during schema generation
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-27078 : unable to determine limit for open files
  • ora-16707 : the value of the property string is invalid, valid values are string
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-31070 : Invalid database user ID string
  • ora-27159 : failure setting process scheduling priority
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-12068 : updatable mview log for mview "string"."string" does not exist
  • ora-23615 : Block number string does not exist for script string
  • ora-39143 : dump file "string" may be an original export dump file
  • ora-30189 : reserved for future use
  • ora-32145 : Environment not specified
  • ora-01117 : adding file 'string' with illegal block size: string; limit is string
  • ora-01271 : Unable to create new file name for file string
  • ora-24192 : the property name cannot be null
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • 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.