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

Oracle 85 Views 0 Min Read

Oracle Error Message

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

Reason for the Error

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.

Solution

Remove one of offending clauses.

Tags: