| User quotas on Tablespace [message #57043] |
Fri, 16 May 2003 05:53  |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
Hi all,
Users in my database were allocated certain quota on the TEMP tablespace (a dictionary managed TBS). At some point in time I had to drop the TEMP tablespace and create a new one called TEMP2; all users with quotas on the TEMP were assigned same quotas on the new TEMP2.
I later observed that a query of DBA_TS_QUOTAS still listed the old temporary tablespace (TEMP) for the users along with the new quotas on TEMP2.
Why am I still having this from the view and how do I
get the old non-existing TEMP tablespace off the list?
Any help would be appreciated.
Many thanks,
Suraj
|
|
|
|
| Re: User quotas on Tablespace [message #57051 is a reply to message #57043] |
Fri, 16 May 2003 21:58  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
couple of questions:
is the temp/temp2 tablespace used only for sorts?
if so, why are you assigning a qouta to users?
every user gets assigned a temporary tablespace and there is no need to assign them a quota.
CREATE USER fred IDENTIFIED BY fred
TEMPORARY TABLESPACE temp;
or
ALTER USER fred TEMPORARY TABLESPACE temp1;
|
|
|
|
| Re: User quotas on Tablespace [message #57070 is a reply to message #57051] |
Mon, 19 May 2003 09:13 |
Suraj
Messages: 38
Registered: April 2002
|
Member |
|
|
The temporary tablespace is used for sort by user processes.
The users were all created with unlimited quotas in actual fact at setup as in the case with the new TEMP2.
An attempt to remove the quota on the old temp with the following command
ALTER USER username
QUOTA 0 ON temp;
did not work as the temp does not exists anymore.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
