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

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

  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-39099 : cannot create index for "string" on master table string
  • ora-02836 : Unable to create temporary key file
  • ora-19561 : %s requires a DISK channel
  • ora-23346 : primary key or object ID is undefined for table or materialized view string
  • ora-16658 : unobserved Fast-Start Failover configuration
  • ora-00451 : foreground process died unexpectedly
  • ora-25207 : enqueue failed, queue string.string is disabled from enqueueing
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-08498 : Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-14008 : missing THAN keyword
  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-14053 : illegal attempt to modify string in string statement
  • ora-33076 : (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.
  • ora-01179 : file string does not exist
  • ora-24363 : measurements in characters illegal here
  • ora-38720 : Missing log file number.
  • ora-01585 : error identifying backup file string
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-02461 : Inappropriate use of the INDEX option
  • ora-06915 : CMX: unknown t_event in datarq
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-19710 : unsupported character set string
  • ora-30350 : specified dimension attribute does not exist
  • ora-01871 : the number of seconds must be less than 60
  • ora-24414 : Only number sessions could be started.
  • ora-12981 : cannot drop column from an object type table
  • ora-16164 : LGWR network server host detach error
  • 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.