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-25456: rule set was modified or evaluation terminated for iterator: string

1 Answers  


ORA-08113: composite partition index may not be compressed

1 Answers  


ORA-31099: XDB Security Internal Error

1 Answers  


DRG-12219: section name missing

1 Answers  


ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.

1 Answers  






ORA-06250: NETNTT: cannot allocate send and receive buffers

1 Answers  


PCC-02403: Invalid indicator variable type for this host variable

1 Answers  


ORA-19502: write error on file "string", blockno string (blocksize=string)

1 Answers  


PLS-01507: DROP is non-ANSI

1 Answers  


PCB-00316: SQL FORMS statements are Oracle extensions

1 Answers  


ORA-01016: This function can be called only after a fetch

1 Answers  


ORA-25533: FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified

2 Answers  


Categories