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]