ORA-14318: DEFAULT partition must be last partition specified

Cause : A aprttiio ndecsritpio nfollow sth eon edecsriibngt hed efualtp arittino

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

Enusret ha tth eDEAFUL Tpatritoin si teh lsat aprttiio ndecsritpion

update : 29-04-2017
ORA-14318

ORA-14318 - DEFAULT partition must be last partition specified
ORA-14318 - DEFAULT partition must be last partition specified

  • ora-36618 : (XSAGMODDIM00) workspace object is not a valid model for AGGMAP ADD.
  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-07637 : smsdbp: buffer protect option not specified when sga created
  • ora-06747 : TLI Driver: error in listen
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-02091 : transaction rolled back
  • ora-12063 : unable to apply transaction from site string
  • ora-07744 : slemcl: invalid error message file handle
  • ora-30937 : No schema definition for 'string' (namespace 'string') in parent 'string'
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-02775 : Invalid request done signal
  • ora-12839 : cannot modify an object in parallel after modifying it
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-21503 : program terminated by fatal error
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-38850 : an enabled thread missing from control file
  • ora-01987 : client os username is too long
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-02717 : osnpfs: incorrect number of bytes written
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-13521 : Unregister operation on local Database id (string) not allowed
  • ora-36682 : (XSDPART20) Partition name string appears twice.
  • ora-07443 : function string not found
  • ora-10651 : incorrect file number block number specified
  • ora-16655 : specified target standby database invalid
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-26505 : unexpected internal null
  • 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.