Anand Blogspot
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment