How to fix the Oracle error ORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.?

In this post, you’ll learn more about the Oracle ErrorORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.

Reason for the Error ORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.

DELETE is allowed in multiwriter mode only for SESSION dimension members

How to fix the Error ORA-37031: (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode. ?

You can fix this error in Oracle by following the below steps

Attach the AW in a R/W mode and perform the DELETE operation