ORA-14639: SUBPARTITIONS clause can be specfied only for
Hash, Composite Range Hash table/partition



ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table/partition..

Answer / guest

Cause: Attempted to specify SUBPARTITIONS clause on table
that is not partitioned by the Composite Range-Hash method

Action: Reissue the command after ensuring that the
SUBPARTITIONS clause is not specified, to specify a template
for a Composite Range List object use 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

RMAN-08517: backup piece handle=string recid=string stamp=string

1 Answers  


ORA-19611: backup piece out of order. Expected string but found string

1 Answers  


ORA-27472: invalid metadata attribute string

1 Answers  


NZE-28750: unknown error

1 Answers  


DRG-11120: failed to write to file string

1 Answers  






PCC-00083: Bind and define variables not allowed in CREATE statement

1 Answers  


ORA-23440: incorrect public template value

1 Answers  


ORA-01874: time zone hour must be between -12 and 13

1 Answers  


RMAN-06078: the controlfile is older than datafile string

1 Answers  


ORA-26681: command type not supported

1 Answers  


ORA-02445: Exceptions table not found

1 Answers  


ORA-19621: archivelog range has already been specified

1 Answers  


Categories