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 SUBPA..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00043: LDAP open failure

1 Answers  


ORA-32501: Writing SGA to file failed

1 Answers  


DGM-16910: unable to issue command to server

1 Answers  


ORA-02273: this unique/primary key is referenced by some foreign keys

2 Answers   KIIT,


NNL-00268: Enter name server password:

1 Answers  






NID-00604: No control files found in database

1 Answers  


SQL*Loader-00258: Maximum number of SORTED INDEXES (number) exceeded on table string

1 Answers  


ORA-12062: transaction string received out of sequence from site string

1 Answers  


O2F-00322: Unable to close the OUTTYPE file

1 Answers  


PLS-00729: only widening of the collection element type is allowed

1 Answers  


RMAN-06101: no channel to restore a backup or copy of the controlfile

1 Answers  


PLS-00437: FORALL bulk index cannot be used in string clause

1 Answers  


Categories