Home » RDBMS Server » Server Administration » Quota assigned to user (Oracle 11gr2,Linux 6)
Quota assigned to user [message #602183] Sun, 01 December 2013 00:11 Go to next message
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 #602186 is a reply to message #602183] Sun, 01 December 2013 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 58937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Assigning a default tablespace does not grant any quota on it.

Re: Quota assigned to user [message #602190 is a reply to message #602186] Sun, 01 December 2013 02:18 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Michel,

Quote:
Assigning a default tablespace does not grant any quota on it.

Can you tell me how much quota to give for a user in dev environment ?

Thanks
Re: Quota assigned to user [message #602196 is a reply to message #602190] Sun, 01 December 2013 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 58937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please, can you think before posting a question.

Re: Quota assigned to user [message #602219 is a reply to message #602196] Sun, 01 December 2013 17:16 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>Can you tell me how much quota to give for a user in dev environment ?
how big is big enough?
will same answer be true & the same for every user in every dev environment?
Re: Quota assigned to user [message #602231 is a reply to message #602190] Mon, 02 December 2013 02:59 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, 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
Re: Quota assigned to user [message #602382 is a reply to message #602231] Tue, 03 December 2013 21:30 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you very much Gazzag..
Previous Topic: Migrating MS SQL into Oracle database
Next Topic: Tables need to move from one Tablespace to another
Goto Forum:
  


Current Time: Fri Aug 29 11:24:12 CDT 2014

Total time taken to generate the page: 0.12937 seconds