Is there a query I can run to show me indexes and their corresponding tables. I just moved a bunch of tables and I am trying to determine which indexes I need to rebuild based off of the names of the tables I moved.
thanks,
lacey
Printable View
Is there a query I can run to show me indexes and their corresponding tables. I just moved a bunch of tables and I am trying to determine which indexes I need to rebuild based off of the names of the tables I moved.
thanks,
lacey
select table_name, index_name from dba_indexes
where table_name = 'XYZ'
order by index_name
select x.table_name, y.index_name
from dba_tables x, dba_indexes y
where x.table_name = y.table_name and x.tablespace_name='AFFAIRS_DATA'
order by x.tablespace_name ;
[Edited by sreddy on 01-11-2001 at 03:03 PM]