Quota assigned to user [message #602183] |
Sun, 01 December 2013 00:11  |
 |
Jack14
Messages: 497 Registered: December 2011 Location: INDIA
|
Senior Member |
|
|
Hi,
I created new user and new tablespace and assigned that new tablespace to the user as below
ALTER USER TEST default tablespace TEST_REPORTING ;
But when i query dba_ts_quotas , i see TEST user is assigned to USERS tablespace.
SQL> SELECT username,tablespace_name, bytes, max_bytes
2 FROM dba_ts_quotas
3 WHERE max_bytes = -1
4 /
USERNAME TABLESPACE_NAME BYTES MAX_BYTES
------------------------------ ------------------------------ ---------- ----------
TEST USERS 0 -1
DEMO_DB DEMO 36044800 -1
APPQOSSYS SYSAUX 0 -1
JACK JACK 8257536 -1
But in dba_users i see user is assigned to test_reporting tablespace.
SQL> select username,account_status,default_tablespace from dba_users where username='TEST';
USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
------------------------------ -------------------------------- ------------------------------
TEST OPEN TEST_REPORTING
Can you tell me how ?
Thanks
|
|
|
|
|
|
|
Re: Quota assigned to user [message #602231 is a reply to message #602190] |
Mon, 02 December 2013 02:59   |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
If you don't know, you can set the quota to UNLIMITED:
ALTER USER <username> QUOTA UNLIMITED ON <tablespace_name>;
Naturally this means that the user could potentially fill up the whole tablespace, but it might give you an idea how much to assign to users in future once they have been running for a while.
HTH
-g
|
|
|
|