cannot specify <(sub)partition-description> clause in CREATE TABLE or CREATE INDEX

Solution ID:ORA-14170

Type: Oracle

Cause

A request was made to generate default partition description(s) (possibly via PARTITIONS <number-of-partitions>) while at the same time specified <(sub)partition-description> clause which is illegal.

Actions

Ensure that the statement describes exactly one subpartition to be moved and that it does not contain any commas

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


Browse all solutions to database errors from Oracle, MS SQL, or MySQL