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 : 24-05-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-00740 : datafile size of (string) blocks exceeds maximum file size
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-07741 : slemop: $OPEN failure
  • ora-24326 : handle passed in is already initialized
  • ora-22632 : AnyDataSet parameter is not valid for the current operation
  • ora-12729 : invalid character class in regular expression
  • ora-30455 : summary contains VARIANCE without corresponding SUM & COUNT
  • ora-06111 : NETTCP: disconnect failure
  • ora-06805 : TLI Driver: could not send datagram SAP packet for SPX
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-26506 : null global context
  • ora-14274 : partitions being merged are not adjacent
  • ora-12657 : No algorithms installed
  • ora-14108 : illegal partition-extended table name syntax
  • ora-31614 : routine string received this error from string: string
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-27064 : cannot perform async I/O to file
  • ora-07393 : unable to delete text file
  • ora-19001 : Invalid storage option specified
  • ora-28179 : client user name not provided by proxy
  • ora-13900 : missing or invalid parameter string
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-16092 : dependent archive log destination is not active
  • ora-19013 : Cannot create VARRAY columns containing XMLType
  • ora-07213 : slgcs: times error, unable to get wall clock.
  • ora-16145 : archival for thread# string sequence# string in progress
  • ora-12446 : Insufficient authorization for administration of policy string
  • ora-38760 : This database instance failed to turn on flashback database
  • ora-01076 : multiple logons per process not yet supported
  • ora-27061 : waiting for async I/Os failed
  • 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.