Friday 11 May 2012

ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole

Cause: User attempted to UPDATE BLOCK REFERENCES on a partitioned index using ALTER INDEX UPDATE BLOCK REFERENCES statement, which is illegal.

Action: Issue a partition level operation with ALTER INDEX .. PARTITION .. UPDATE BLOCK REFERENCES

No comments:

Post a Comment