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 : 26-07-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-27544 : Failed to map memory region for export
  • ora-08458 : invalid format parameter
  • ora-31065 : Cannot modify read-only property [string]
  • ora-00261 : log string of thread string is being archived or modified
  • ora-01926 : cannot GRANT to a role WITH GRANT OPTION
  • ora-13011 : value is out of range
  • ora-21601 : attribute is not an object
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-31484 : source database version must be at least 9.2.0.6 or greater
  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-16757 : resource guard could not get property
  • ora-24024 : Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
  • ora-00042 : Unknown Service name string
  • ora-22165 : given index [string] must be in the range of [string] to [string]
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-06262 : NETNTT: nfconn() failed
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-29810 : inadequate operator privileges
  • ora-01989 : role 'string' not authorized by operating system
  • ora-02441 : Cannot drop nonexistent primary key
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-01692 : unable to extend lob segment string.string partition string by string in tablespace string
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-13423 : invalid cell coordinate parameter
  • ora-12657 : No algorithms installed
  • ora-25406 : could not generate a connect address
  • 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.