Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-31038: Invalid string value: "string"

1 Answers  


ORA-02828: Segment free list is empty

1 Answers  


IMP-00067: Could not convert to server character set's handle

1 Answers  


ORA-22339: cannot alter to not final since its attribute column is substitutable

1 Answers  


TNS-01170: Event detection broke for address: string

1 Answers  






ORA-16017: cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination

1 Answers  


ORA-32026: %s.string has fewer columns compared to string table.

1 Answers  


ORA-12059: prebuilt table "string"."string" does not exist

1 Answers  


ORA-13374: SDO_MBR not supported for geodetic data

1 Answers  


ORA-16164: LGWR network server host detach error

1 Answers  


ORA-30569: data type of given column is not supported in a log group

1 Answers  


ORA-06116: NETTCP: unable to create ORASRV process

1 Answers  






Categories