Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.