Oracle Solution for Error ora-36921

Solution for Oracle Error ORA-36921

ORA-36921: (XSVPMVTOPART02) workspace object

and workspace object

are not in the same analytic workspace.

What triggered 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.

What should we do to fix it:

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.