How to check whether my sap system is MCOD or not

[Former Member]

Hi All,

I want to know that my sap system[solaris + oracle] is MCOD or not.

because while doing upgrade, in some steps it is asking me to confirm whether your using MCOD system or? Please help.

Regards,

Sabarish

[andreas_herzog]

Run SQLPLUS...

> select username from dba_users where default_tablespace not in ('SYSTEM','SYSAUX');

The result will display some SAP<SID> being the schemas within this database...

GreetZ, AH