ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table

Cause : SBUPRATTIINO ETMLPAET acnb es pceiife dolnyf o rcmopsoiet aprittoinde atbels

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

D onto sueS UPBATRIITO NTMEPALT Eo nnno-aprittoinde ro onnc-opmoist eprattiinoe dtbalse.

update : 25-04-2017

ORA-14602 - SUBPARTITION TEMPLATE is legal only for a composite partitioned table
ORA-14602 - SUBPARTITION TEMPLATE is legal only for a composite partitioned table

  • ora-25141 : invalid EXTENT MANAGEMENT clause
  • ora-25205 : the QUEUE string.string does not exist
  • ora-31413 : change set string is currently being advanced
  • ora-26734 : different datafiles_directory_object parameter must be specified
  • ora-16771 : failover to a physical standby database failed
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-14167 : only one subpartition may be moved
  • ora-28578 : protocol error during callback from an external procedure
  • ora-30001 : trim set should have only one character
  • ora-34183 : (MXCHGDCL22) Partition number already exists.
  • ora-07615 : $CHANGE_CLASS failed in retrieving the specified file label
  • ora-10863 : Control behavior of buffered background operations
  • ora-13607 : The specified task or object string already exists
  • ora-01168 : physical block size string does not match size string of other members
  • ora-19234 : XQ0014 - invalid or unsupported must-understand extension
  • ora-10647 : Tablespace other than SYSTEM, string, string not found in read only mode
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-01314 : Name of the column to be mined should be a string literal
  • ora-00222 : operation would reuse name of a currently mounted control file
  • ora-13270 : OCI error string
  • ora-23323 : parameter length exceeds deferred RPC limits
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-19860 : piece validation cannot be performed more than once
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-01197 : thread string only contains one log
  • ora-31519 : CDC subscription string already exists
  • ora-08316 : sllfsk: Error seeking in file.
  • ora-16719 : unable to query V$ARCHIVE_DEST fixed view
  • 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.