Oracle Error ORA-36921: (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.

Oracle Error Message

ORA-36921: (XSVPMVTOPART02) workspace object and workspace object are not in the same analytic workspace.

Reason for the Error

The OLAP DML command requires certain objects to be in the same analytic workspace, and the command string specified objects from two different analytic workspaces.

Solution

If more than one analytic workspace is attached to the session, make sure that the object names given in the command are unique across all attached analytic workspaces. Use qualified object names (QON’s) if necessary.