Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tables Quota Usage - How?

Re: Tables Quota Usage - How?

From: Harry Sheng <hsheng_at_innovance.com>
Date: Thu, 5 Sep 2002 14:27:02 -0400
Message-ID: <cqNd9.10459$H67.54569@tor-nn1.netcom.ca>

Try something like

select bytes from user_segments where segment_type='TABLE' and segment_name='[table-name]'

"Emil Nikolov" <emil_nikolov_at_hotmail.com> wrote in message news:461451f7.0209050818.42237d4d_at_posting.google.com...
> Is there a way to find out what table is using what amount of space?
> I know how to get the total user quota usage, but if I can get it to a
> table level it would be much more helpful.
>
> Thanx.
>
> Emil Nikolov
Received on Thu Sep 05 2002 - 13:27:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US