What should the default tablespace be for SAP users

[Former Member]

I'm using Oracle 10.2.0.4

For the users

OPS$<SID>ADM

OPS$ORA<SID>

SAP<SID>

what should the default tablespace be

PSAP<SID>USR or PSAP<SID>

[Former Member · Accepted solution]

Hello Bill,

> For the users

> OPS$<SID>ADM

For this user the default tablespace is SYSTEM

> OPS$ORA<SID>

For this user the default tablespace is SYSTEM

> SAP<SID>

For this user the default tablespace is PSAPPRDUSR

Regards,

Federico Biavati