select t.owner,t.segment_name,t.segment_type,a.name,t.file_id
from dba_extents t,v$datafile a
where t.file_id=file#
and t.segment_name='EMP'
select b.tablespace_name,b.file_name from dba_extents a ,dba_data_files b
where a.owner='table_owner'
and a.segment_name='table_name'
and a.file_id=b.file_id
阅读(695) | 评论(0) | 转发(0) |