OraFAQ Forum: Server Administration » Quota assigned to user

Home » RDBMS Server » Server Administration » Quota assigned to user (Oracle 11gr2,Linux 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Code: [Select all] [Show/ hide]

ALTER USER TEST default tablespace TEST_REPORTING ;

But when i query dba_ts_quotas , i see TEST user is assigned to USERS tablespace.

Code: [Select all] [Show/ hide]

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.

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Quota assigned to user [message #602186 is a reply to message #602183]

Sun, 01 December 2013 00:53

Michel Cadot
Messages: 68739
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Quota assigned to user [message #602190 is a reply to message #602186]

Sun, 01 December 2013 02:18

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

Report message to a moderator

Re: Quota assigned to user [message #602196 is a reply to message #602190]

Sun, 01 December 2013 05:46

Michel Cadot
Messages: 68739
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please, can you think before posting a question.

Report message to a moderator

Re: Quota assigned to user [message #602219 is a reply to message #602196]

Sun, 01 December 2013 17:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

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:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Quota assigned to user [message #602382 is a reply to message #602231]

Tue, 03 December 2013 21:30

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you very much Gazzag..

Report message to a moderator

Previous Topic:	Migrating MS SQL into Oracle database
Next Topic:	Tables need to move from one Tablespace to another

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 00:12:13 CST 2025