ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template

Cause : Cnanto pseicf ytehs ecaluessw hlies pceiyfign atmepalte

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

Crorcett h esbuprattiino etmlpaet lcasue.

update : 28-07-2017

ORA-14601 - Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template
ORA-14601 - Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template

  • ora-29509 : incorrectly formed Java binary class definition
  • ora-00294 : invalid archivelog format specifier 'string'
  • ora-27027 : sbtremove2 returned error
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-02829 : No segment of the proper size is available
  • ora-26718 : transaction limit reached
  • ora-02771 : Illegal request time out value
  • ora-25276 : table specified is not a queue table
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-16052 : DB_UNIQUE_NAME attribute is required
  • ora-01263 : Name given for file destination directory is invalid
  • ora-17619 : max number of processes using I/O slaves in a instance reached
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-27507 : IPC error disconnecting from a port
  • ora-31406 : change source string is referenced by a change set
  • ora-01931 : cannot grant string to a role
  • ora-13385 : error in network manager: [string]
  • ora-22334 : cannot reset type "string"."string". Dependent tables must be upgraded to latest version
  • ora-16792 : configuration property value is inconsistent with database setting
  • ora-08184 : attempting to re-enable Flashback while in Flashback mode
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-28331 : encrypted column size too long for its data type
  • ora-12562 : TNS:bad global handle
  • ora-26094 : stream format error: input column overflow
  • ora-15078 : ASM diskgroup was forcibly dismounted
  • ora-25333 : Buffered Queue to Queue propagation did not connect to the correct instance
  • 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.