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

TNS-01186: Client connection was dropped based on a filtering rule

1 Answers  


RMAN-12016: using channel string

1 Answers  


ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

1 Answers  


ORA-29741: IMR active for some, but not all members of cluster

1 Answers  


ORA-25143: default storage clause is not compatible with allocation policy

1 Answers  






LSX-00120: value is not valid restriction of parent's maxLength

1 Answers  


NZE-28796: access method is not supported

1 Answers  


ORA-14070: option may be specified only for partitioned indices or with REBUILD

1 Answers  


PCC-00138: Result Set Cursors are not implemented in this precompiler

1 Answers  


LRM-00117: syntax error at 'string' at the start of input

1 Answers  


ORA-22320: missing user version string

1 Answers  


ORA-32638: Non unique addressing in MODEL dimensions

1 Answers  


Categories