Showing posts with label Composite Range Hash table or partition. Show all posts
Showing posts with label Composite Range Hash table or partition. Show all posts

Sunday, 18 March 2012

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

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

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