Oracle Error ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

Oracle Error Message

ORA-34489: (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.

Reason for the Error

The user attempted to use the MAINTAIN command on a dimension surrogate. The MAINTAIN command can only be used with real dimensions, not surrogates.

Solution

Use the MAINTAIN command to modify the underlying dimension of the surrogate instead.