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 : 23-08-2017

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

  • ora-32775 : cannot change size attributes of read only tablespace string
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-13121 : layer type type mismatch with topo_geometry layer type
  • ora-24377 : invalid OCI function code
  • ora-15107 : missing or invalid ASM disk name
  • ora-02849 : Read failed because of an error
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-08265 : create_ora_addr: cannot open nameserver
  • ora-04044 : procedure, function, package, or type is not allowed here
  • ora-08414 : error encountered in string
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-24098 : invalid value string for string
  • ora-00338 : log string of thread string is more recent than control file
  • ora-01519 : error while processing file 'string' near line string
  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-00064 : object is too large to allocate on this O/S (string,string)
  • ora-02789 : Maximum number of files reached
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-16182 : Internal error on internal channel during remote archival
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-16196 : database has been previously opened and closed
  • ora-33098 : (APABBR01) A value of 'string' is not valid for the workspace object option.
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-16605 : unable to delete template, template is in use
  • ora-07589 : spdde: system ID not set
  • ora-24769 : cannot forget an active transaction
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • 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.