| New Temp tablespace [message #62333] |
Thu, 15 July 2004 01:25  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
Hi,
I created a new temporary tablespace in Oracle 9i and made it default temp tablespace for the database i checked with dba_users that all the users are now having new temp tablespace as the default temp tablespace.
Now my question is " Do i need to give quota on the temp tablespace to all users"
Please reply me with the appropriate soln.
thanks in advance
Vivek
|
|
|
|
| Re: New Temp tablespace [message #62337 is a reply to message #62333] |
Thu, 15 July 2004 03:08  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
No, there is no need to expilicitly grant quota on temporary tablespace to users. Quota should be defined on only the data tablespaces not for undo or temp.
Daljit Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
