OraFAQ Forum: General » Oracle Quota

Home » Other » General » Oracle Quota

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

Oracle Quota [message #104628]

Fri, 17 December 2004 04:54

Sreenivasa Rao Ramanuja
Messages: 3
Registered: December 2004

Junior Member

How to view a user's quota on his Tablespace?

Report message to a moderator

Re: Oracle Quota [message #104633 is a reply to message #104628]

Mon, 20 December 2004 02:41

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Here is an example:

SQL> select * from user_ts_quotas;

TABLESPACE_NAME                     BYTES  MAX_BYTES     BLOCKS MAX_BLOCKS
------------------------------ ---------- ---------- ---------- ----------
USERS                             2555904          0        312          0
SYSTEM                                  0   10485760          0       1280

Best regards.

Frank

Report message to a moderator

Re: Oracle Quota [message #104698 is a reply to message #104628]

Wed, 05 January 2005 03:53

Sreenivasa Rao Ramanuja
Messages: 3
Registered: December 2004

Junior Member

To View Quota on his / her tablespace query the following data dictionary user_ts_quotas.

Report message to a moderator

Previous Topic:	Learning Oracle
Next Topic:	error in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 18:49:52 CST 2024