ORA-14299: total number of partitions/subpartitions exceeds the maximum limit

Cause : The total number of combined fragments specified in partitions /subpartitions exceeds 1048575.

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

Reissue the statement with fewer number of fragments

update : 24-07-2017
ORA-14299

ORA-14299 - total number of partitions/subpartitions exceeds the maximum limit
ORA-14299 - total number of partitions/subpartitions exceeds the maximum limit

  • ora-31676 : illegal value for number of workers, string
  • ora-24049 : invalid agent name string, names with AQ$_ prefix are not valid
  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-27078 : unable to determine limit for open files
  • ora-15020 : discovered duplicate ASM disk "string"
  • ora-27029 : skgfrtrv: sbtrestore returned error
  • ora-31168 : Node localname and namespace values should be less than 64K
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-09704 : sstascre: ftok error in creating test and set pages.
  • ora-08105 : Oracle event to turn off smon cleanup for online index build
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-29546 : badly formed resource: string
  • ora-01590 : number of segment free list (string) exceeds maximum of string
  • ora-26530 : unable to build materialized view refresh control list
  • ora-02179 : valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-24369 : required callbacks not registered for one or more bind handles
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-39304 : conflicting changes to object "string" : string
  • ora-32633 : MODEL subquery FOR cell index returns too many rows
  • ora-28169 : unsupported certificate type
  • ora-26666 : cannot alter STREAMS process string
  • ora-12316 : syntax error in database link's connect string
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-21300 : objects option not installed
  • ora-28046 : Password change for SYS disallowed
  • ora-24270 : a row already exists in the string table for these parameters
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-30187 : reserved for future use
  • 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.