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

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

  • ora-02059 : ORA-2PC-CRASH-TEST-string in commit comment
  • ora-19036 : Invalid query result set in newContextFromHierarchy()
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-32620 : illegal subquery within MODEL rules
  • ora-09926 : Unable to set effective privilege set of the server
  • ora-07442 : function address must be in the range string to string
  • ora-12447 : policy role already exists for policy string
  • ora-12417 : database object "string" not found
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-07760 : slemtr: $open failure
  • ora-00160 : global transaction length string is greater than maximum (string)
  • ora-25135 : cannot use the SINGLE TABLE option
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-25248 : duplicate agent specified in the agent list
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-12631 : Username retrieval failed
  • ora-32607 : invalid ITERATE value in MODEL clause
  • ora-39160 : error on whats my name call
  • ora-23336 : priority group string does not exist
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-36843 : (XSLMGEN13) Dimension string.string!string hierarchy string is missing a PHYSICALNAME property value
  • ora-31065 : Cannot modify read-only property [string]
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-13388 : invalid value for dst_spec parameter
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-07823 : sspsqr: $QIO failure
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • 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.