1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest


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

TNS-01043: Password changed for string

1 Answers  

RMAN-06598: conversion between platforms 'string' and 'string' is not needed

1 Answers  

ORA-14072: fixed table may not be truncated

1 Answers  

IMG-00505: missing value in CUT rectangle

1 Answers  

ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  




ORA-01171: datafile string going offline due to error advancing checkpoint

1 Answers  

ORA-26004: Tables loaded through the direct path may not be clustered

1 Answers  

ORA-00475: TRWR process terminated with error

1 Answers  

ORA-39106: Worker process string failed during startup. Worker error:

1 Answers  

ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.

1 Answers  

ORA-15050: disk "string" contains string error(s)

1 Answers  

TNS-00296: Stoppable : string

1 Answers  

For more Oracle Errors Interview Questions Click Here
Categories