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 : 24-05-2017

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

  • ora-29301 : wrong DBMS_PITR package function/procedure order
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • ora-01534 : rollback segment 'string' doesn't exist
  • ora-09844 : soacon: Archmon unable to open named pipe.
  • ora-13266 : error inserting data into table string
  • ora-27125 : unable to create shared memory segment
  • ora-25112 : maximum number of BITMAP index columns is 30
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • ora-07595 : sppid: $GETJPIW failure
  • ora-38609 : FI Not enough memory for tree counting, requires at least stringKB
  • ora-09835 : addCallback: callback port is already in a set.
  • ora-16580 : bad Data Guard NetSlave network link
  • ora-19647 : non-zero LEVEL cannot be specified when INCREMENTAL is FALSE
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-01668 : standby database requires DROP option for offline of data file
  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-12011 : execution of string jobs failed
  • ora-02195 : Attempt to create string object in a string tablespace
  • ora-27486 : insufficient privileges
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-10638 : Index status is invalid
  • ora-30047 : Internal event for kti tracing
  • ora-19121 : duplicate attribute definition - string
  • ora-31023 : Index size error
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-37158 : Bad clob or varray IN-args: (case string)
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-09275 : CONNECT INTERNAL is not a valid DBA connection
  • ora-01341 : LogMiner out-of-memory
  • 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.