Sunday, 17 June 2012

ORA-38496: Expression Filter index is not in a valid state

ORA-38496: Expression Filter index is not in a valid state

Cause: An attempt was made to REBUILD an Expression Filter index that was not valid.

Action: Use DEFAULT keyword in the parameters clause to rebuild the index from defaults or drop and recreate the index.

No comments:

Post a Comment