Re: Calculating new tablespace sizes

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in article <35FA2DB9.7F5FE70A_at_sybrandb.demon.nl>...
> Hi Andy,
>
> select segment_type, sum(bytes)/1024 K
> from dba_segments
> where owner = <your owner>
> and segment_type in ('TABLE','INDEX')
> group by segment_type;

Sybrand,

Thanks for the advice and the calculation!

Andy Received on Sat Sep 12 1998 - 23:59:11 CDT