Oracle Error ORA-37527: (XSCHGDFN01) SESSION values of dimension string are being automatically deleted.

Oracle Error Message

ORA-37527: (XSCHGDFN01) SESSION values of dimension string are being automatically deleted.

Reason for the Error

When using CHGDFN to rebuild the hash index of a TEXT or NTEXT dimension, SESSION values were encountered.

Solution

Recreate the SESSION values after the CHGDFN command completes. Information about the deleted values has been written to the trace file.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...