ORA-28139: Maximum allowed Fine Grain Audit Policies Exceeded

Cause : A maximum of 256 policies can be enabled on an object

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

Drop or disable an existing policy before creating more

update : 26-05-2017
ORA-28139

ORA-28139 - Maximum allowed Fine Grain Audit Policies Exceeded
ORA-28139 - Maximum allowed Fine Grain Audit Policies Exceeded

  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-25456 : rule set was modified or evaluation terminated for iterator: string
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-16509 : the request timed out
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-01277 : file 'string' already exists
  • ora-12315 : database link type is invalid for the ALTER DATABASE statement
  • ora-12818 : invalid option in PARALLEL clause
  • ora-28170 : unsupported certificate version
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-25503 : cannot open database because the database is being quiesced
  • ora-01355 : logminer tablespace change in progress
  • ora-15180 : Could not open dynamic library string, error [string]
  • ora-28138 : Error in Policy Predicate
  • ora-16704 : cannot modify a read-only property
  • ora-19250 : XQ0030 - too many values to validate expression
  • ora-01603 : illegal grouping size in clause "string" of string
  • ora-02398 : exceeded procedure space usage
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-07821 : sspsdn: SYS$DELLNM failure
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-31609 : error loading file "string" from file system directory "string"
  • ora-24782 : Cannot detach from a non-migratable transaction
  • ora-26505 : unexpected internal null
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-39037 : Object type path not supported for string metadata filter.
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • 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.