col OWNER for a45;
col SEGMENT_NAME for a45;
set linesize 200;
select tablespace_name,segment_type,owner,segment_name from dba_extents where file_id=499 and 2211593 between block_id and block_id + blocks -1;
Oracle查看某个数据块所在的表空间、段、对象
最新推荐文章于 2024-07-12 07:13:33 发布