Thursday 15 March 2012

ORA-14175: a subpartition maintenance operation may not be combined with other operations

ORA-14175: a subpartition maintenance operation may not be combined with other operations

Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a subpartition maintenance operation (e.g. MOVE SUBPARTITION) with some other operation (e.g. MODIFY PARTITION ADD SUBPARTITION or PCTFREE) which is illegal

Action: Ensure that a subpartition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with subpartitions, default attributes of partitioned tables or indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will

No comments:

Post a Comment