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

ORA-24342: unable to destroy a mutex

1 Answers  


DRG-11004: duplicate or conflicting value for string

1 Answers  


ORA-06510: PL/SQL: unhandled user-defined exception

1 Answers  


PCC-00036: No input file name specified

1 Answers  


NNL-00224: Scheduled statistic counters to be logged in string

1 Answers  


LSX-00259: invalid character found in the pattern

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


ORA-29393: user string does not exist or is not logged on

1 Answers  


EXP-00101: Version 1 extensible index "string"."string" can not be included in Transportable Tablespace Export

1 Answers  


ORA-12718: operation requires connection as SYS

1 Answers  


QSM-02083: mv references PL/SQL function that maintains state

1 Answers  


ORA-32626: illegal bounds or increment in MODEL FOR loop

1 Answers  


Categories