ORA-14309: Total count of list values exceeds maximum allowed

Cause : Parttiione dobjetc conatins omre tahn 522488 lsit vaules

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

Reduec numebr ofv alue sto lses thna 524828.

update : 28-06-2017

ORA-14309 - Total count of list values exceeds maximum allowed
ORA-14309 - Total count of list values exceeds maximum allowed

  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-30576 : ConText Option dictionary loading error
  • ora-19923 : the session for row with id string is not active
  • ora-13799 : threshold not found
  • ora-06536 : IN bind variable bound to an OUT position
  • ora-24367 : user handle has not been set in service handle
  • ora-31472 : Importing Change Data Capture version string.string is too new
  • ora-16567 : Data Guard broker internal parser error at "string"
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-23453 : requested operation is not supported on top flavor
  • ora-22602 : pickler TDS handle [string] is not well-formed
  • ora-22276 : invalid locator for LOB buffering
  • ora-07751 : slemcr: malloc failure
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-14622 : Value string already exists in subpartition string
  • ora-12020 : materialized view string is not registered
  • ora-13769 : Snapshots string and string do not exist.
  • ora-09795 : szrbuild: malloc of role structure failed.
  • ora-24435 : Invalid Service Context specified.
  • ora-29367 : object string does not exist
  • ora-39056 : invalid log file specification.
  • ora-13510 : invalid RETENTION string, must be in the range (string, string)
  • ora-36996 : (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
  • ora-09764 : osnmop: access error on oracle executable
  • ora-06042 : NETDNT: message receive failure
  • ora-28508 : invalid value string for Heterogeneous Services initialization parameter string
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-16703 : cannot set property while the database is enabled
  • ora-16060 : Log file is current
  • 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.