RE: Ouota

From: Elliott, Patrick <Patrick.Elliott_at_bestbuy.com>
Date: Mon, 1 May 2000 15:09:10 -0500
Message-Id: <10484.104606@fatcity.com>

Try the following query.

select username,

       tablespace_name,
       bytes,
       max_bytes,
       blocks,
       max_blocks
from   dba_ts_quotas
where  username        like upper('&username')

  and tablespace_name like upper('&tbsp_name') /

> -----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 - 15:09:10 CDT