3_Index_Object.sql

3_Index_Object.sql

undefine owner

undefine table_name

select index_name, column_name, column_position

from   dba_ind_columns

where  index_name in ( 

select index_name

        from   dba_indexes

        where  owner='&OWNER' 

and table_name = '&TABLE_NAME' );

select t.owner, s.segment_name, s.tablespace_name, t.last_analyzed, t.num_rows, s.bytes/1024/1024 MB

from dba_segments s, dba_indexes t

where s.segment_name=t.index_name

and t.owner='&&OWNER'

and t.table_name='&&TABLE_NAME';