Re: Quota Syntax??

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 15 Apr 1999 09:21:06 +0200
Message-ID: <37159362.A1311681@vnl.nl>

Ron,

try this (assuming you're logged in as system, or have select all tables granted)

select
tablespace_name
, username
, max_bytes
from dba_ts_quotas
order by username
/

A value of -1 for max_bytes indicates unlimited quota.

Ron Franks wrote:

Does anyone know the syntax to find out what a users quota is?
I can alter a users quota, but not sure how to find out what it is.
Thanks.
Ron.Franks@trw.com
TRW System Administrator

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV
-----------------------------------------------
Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046
Received on Thu Apr 15 1999 - 02:21:06 CDT