Re: Table and its Index(es) script..

I didn't get the point think it will work with

select segment_name TABLE_NAME, e.owner, index_name, sum (bytes)/1024/1024 Size_Mbytes

        from dba_extents e, dba_indexes i
        where segment_name like upper('CRCY') and
        segment_name = i.table_name (+) and
        e.owner = i.table_owner (+)
        group by segment_name, e.owner, index_name

Tony Adolph wrote:

> create view v_tab_size_xyxyxy as
> select segment_name TABLE_NAME, e.owner, index_name, sum
> (bytes)/1024/1024 Size_Mbytes
> from dba_extents e, dba_indexes i
> where segment_name like upper('&&table_name') and
> segment_name = i.table_name (+) and
> e.owner = i.owner (+)
> group by segment_name, e.owner, index_name
> /
Received on Sat Jul 10 1999 - 14:00:56 CDT