Try DBA_TS_QUOTAS view.
If no entry for user, then user not allowed to use any space for objects.
MAX_BYTES will be -1 for UNLIMITED.
> -----Original Message-----
> From: French, Bobby (STL) [SMTP:BFrench_at_slpcapital.com]
> Sent: Monday, May 01, 2000 2:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Ouota
>
> Hey everybody,
>
> Where can I find the quota for a particular user?
>
> Thanks...Bobby
> --
> Author: French, Bobby (STL)
> INET: BFrench_at_slpcapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon May 01 2000 - 14:35:35 CDT
