Oracle Database 12c New Features

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

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


Cause:


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



Action:


Remove one of offending clauses.