DB administrator users SYS and SYSTEM - which temporary tablespace?

[Former Member]

Hi,

We have the following scenario where the Oracle DB users SYS and SYSTEM have PSAPTEMP as their temporary tablespace.

USERNAME                       TEMPORARY_TABLESPACE
------------------------------ ------------------------------
SYSTEM                         PSAPTEMP
SYS                            PSAPTEMP

Can anybody confirm if this is the correct approach? Or should the SYSTEM tablespace be used as the temporary tablespace for those two user accounts? What does Oracle/SAP recommend?

Thanks in advance.

[stefan_koehler · Accepted solution]

Hello Wes,

just a simple and quick answer: This is the correct approach.

For more information about temporary tablespaces and the concept of it - please check the documentation or this site:

http://www.dba-oracle.com/concepts/temporary_tablespaces.htm

Regards

Stefan

[Former Member]

Hi,

This approch is correct. Each user is asign to default temporary tablespace i.e PSAPTEMP.

Regards,

Sachin Rane.

[Former Member]

Hi,

This is the correct approch and assignment is by default after installation.

Hope this helps.

Manoj Chintawar