ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified

Cause : Once a subpartition template has been specified during a CREATE TABLE it is illegal to specify SUBPARTITIONS or STORE IN anywhere else

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

Remove either the SUBPARTITIONS | STORE IN or remove the SUBPARTITION TEMPLATE clause

update : 23-04-2017
ORA-14604

ORA-14604 - During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
ORA-14604 - During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified

  • ora-14157 : invalid subpartition name
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-12601 : TNS:information flags check failed
  • ora-26005 : Invalid handle for direct path load
  • ora-39016 : Operation not supported when job is in string state.
  • ora-16570 : operation requires restart of database "string"
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-00566 : cannot request processor group - NUMA not enabled
  • ora-39954 : DEFERRED is required for this system parameter
  • ora-02463 : Duplicate HASH IS option specified
  • ora-39005 : inconsistent arguments
  • ora-22314 : method information mismatch in ALTER TYPE
  • ora-01034 : ORACLE not available
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-16524 : unsupported operation
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-01074 : cannot shut down ORACLE; inside a login session - log off first
  • ora-19610 : directory block string is corrupt
  • ora-10382 : parallel query server interrupt (reset)
  • ora-00375 : unable to get default db_block_size
  • ora-25289 : Buffer Already Exists
  • ora-07580 : spstp: $GETJPIW failure
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-38493 : feature not enabled : Expression Filter index
  • ora-23540 : Redefinition not defined or initiated
  • ora-00447 : fatal error in background process
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-23432 : master site string already exists
  • ora-09843 : soacon: Archmon unable to create named pipe.
  • ora-00402 : database changes by release string cannot be used by release string
  • 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.