Oracle Error ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

Oracle Error Message

ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

Reason for the Error

Persistent object definition in multiwriter mode is not allowed.

Solution

Do all persistent object definitions in read-write mode.