ORA-14624: DEFAULT subpartition must be last subpartition specified

Cause : A subpatrition dsecriptio nfollowst he one edscribin gthe defualt subpratition

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

Ensure htat the EDFAULT sbupartitino is thel ast subaprtitiond escriptoin

update : 26-04-2017
ORA-14624

ORA-14624 - DEFAULT subpartition must be last subpartition specified
ORA-14624 - DEFAULT subpartition must be last subpartition specified

  • ora-29833 : indextype does not exist
  • ora-31107 : Action failed as resource "string" is locked by name lock
  • ora-38702 : Cannot update flashback database log file header.
  • ora-39705 : component 'string' not found in registry
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-34481 : (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.
  • ora-25220 : enqueue failed, signature not specified for a non-repudiable queue
  • ora-08459 : invalid format parameter length
  • ora-16555 : the Data Guard database is not active
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-13303 : failure to retrieve a geometry object from a table
  • ora-19163 : XP0004 - XQuery type mismatch: argument type mismatch: expected - 'string' got - 'string' for function 'string'
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-23432 : master site string already exists
  • ora-22927 : invalid LOB locator specified
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-27198 : skgfpvl: sbtpcvalidate returned error
  • ora-12805 : parallel query server died unexpectedly
  • ora-01507 : database not mounted
  • ora-22866 : default character set is of varying width
  • ora-14268 : subpartition 'string' of the partition resides in offlined tablespace
  • ora-31511 : name exceeds maximum length of 30 characters
  • ora-08234 : smsget: cannot get instance listener address
  • ora-39767 : finish is not allowed when unloaded stream data exists
  • ora-09370 : Windows 3.1 Two-Task driver ORACLE task timed out
  • ora-31635 : unable to establish job resource synchronization
  • ora-12003 : materialized view "string"."string" does not exist
  • ora-37120 : MDX string is null
  • ora-16520 : unable to allocate resource id
  • 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.