ORA-28109: the number of related policies has exceeded the limit of 16

Cause : Too amn yploiice saer nivlovde ni htes aem bojcet.s

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

Dorpo n eo rmroep oilceis .O rcmobniea efwo ft hme nit ooen.

update : 26-05-2017
ORA-28109

ORA-28109 - the number of related policies has exceeded the limit of 16
ORA-28109 - the number of related policies has exceeded the limit of 16

  • ora-02476 : can not create index due to parallel direct load on table
  • ora-14171 : cannot specify clause in CREATE|ALTER TABLE
  • ora-19505 : failed to identify file "string"
  • ora-29273 : HTTP request failed
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-39096 : invalid input value string for parameter string
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-29547 : Java system class not available: string
  • ora-26741 : cannot assemble lobs
  • ora-16094 : database shutdown during archival operation
  • ora-38722 : ON or OFF expected.
  • ora-23435 : cannot create an updatable ROWID materialized view with LOB columns
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-00724 : ALTER DATABASE CONVERT command has been de-supported
  • ora-24413 : Invalid number of sessions specified
  • ora-32401 : materialized view log on "string"."string" does not have new values
  • ora-01250 : Error string occurred during termination of file header access
  • ora-12084 : must use ALTER MATERIALIZED VIEW to alter "string"."string"
  • ora-12720 : operation requires database is in EXCLUSIVE mode
  • ora-02286 : no options specified for ALTER SEQUENCE
  • ora-25464 : ROWID not specified for table alias: string
  • ora-30040 : Undo tablespace is offline
  • ora-26014 : unexpected error on string string while retrieving string string
  • ora-16113 : applying change to table or sequence string
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-29534 : referenced object string.string could not be resolved
  • ora-25313 : a queue may not subscribe to itself for propagation
  • 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.