on 03-09-2009 4:02 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This approch is correct. Each user is asign to default temporary tablespace i.e PSAPTEMP.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is the correct approch and assignment is by default after installation.
Hope this helps.
Manoj Chintawar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.