Saturday, September 9, 2017

Identify data files used by index

select * from dba_data_files
where file_id in(
select distinct file_id from DBA_EXTENTS where segment_name in ('SKU_PK')
intersect
select distinct file_id from DBA_EXTENTS where segment_name in ('XIF7SKU'))

No comments:

Post a Comment