Home » Other » General » Oracle Quota
Oracle Quota [message #104628] Fri, 17 December 2004 04:54 Go to next message
Sreenivasa Rao Ramanuja
Messages: 3
Registered: December 2004
Junior Member
How to view a user's quota on his Tablespace?
Re: Oracle Quota [message #104633 is a reply to message #104628] Mon, 20 December 2004 02:41 Go to previous messageGo to next message
Frank Naude
Messages: 4571
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
Re: Oracle Quota [message #104698 is a reply to message #104628] Wed, 05 January 2005 03:53 Go to previous message
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.
Previous Topic: Learning Oracle
Next Topic: error in oracle
Goto Forum:
  


Current Time: Thu Dec 08 06:46:05 CST 2022