Oracle DBA, How To, Error, Cause and Action

ORA-14271: table is not partitioned by Composite Range method

ORA-14271: table is not partitioned by Composite Range method


Cause:


The table in ALTER TABLE MODIFY SUBPARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Composite Range method which is illegal.



Action:


Ensure that the table is partitioned by Composite Range method

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)