ORA-14631: the partition bounds do not match the subpartition bounds of the partition

Cause : Wehne xhcagnign aprattiinoe dtbal ewtiha ocmopstiep atriito nteh obudnst hta edsrcieb htep atriitosn fo htet albem uts amthc hteb onud stahtd ecsrbiet h esbuprattiinoso ft h ecmopsoiet aprittoin.

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

Esnuer hta tteh obudnsd ecsrbiign aprittoin si nteh aprittoinde atbel si htes aem sa hteb onud so fteh usbaprittoin si nteh htec opmoist eprattiino.

update : 20-07-2017
ORA-14631

ORA-14631 - the partition bounds do not match the subpartition bounds of the partition
ORA-14631 - the partition bounds do not match the subpartition bounds of the partition

  • ora-30649 : missing DIRECTORY keyword
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-13444 : GeoRaster metadata SRS error
  • ora-12406 : unauthorized SQL statement for policy string
  • ora-10561 : block type 'string', data object# string
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-19622 : archivelog thread string sequence string not restored due to string
  • ora-02304 : invalid object identifier literal
  • ora-12984 : cannot drop partitioning column
  • ora-13706 : Invalid value "string" specified for parameter "string" in "string" analysis mode.
  • ora-30687 : session terminated by debugger
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-22304 : input type is not an object type
  • ora-31163 : element or attribute "string" has invalid attribute value "string" (should be "string")
  • ora-23478 : object group "string" is already mastered at string
  • ora-24147 : rule string.string does not exist
  • ora-23421 : job number string is not a job in the job queue
  • ora-36681 : (XSDPART19) Partitions string and string are out of order.
  • ora-01231 : cannot make read write - file string is offline
  • ora-31003 : Parent string already contains child entry string
  • ora-09959 : IMON: deletion of a process failed.
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-13441 : GeoRaster metadata SRS error
  • ora-01151 : use media recovery to recover block, restore backup if needed
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-37174 : source SQL must be a SELECT statement
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-30966 : error detected in the XML Index layer
  • 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.