Oracle Object list via File and Block ID. ..
set pause on pagesize 100 linesize 300 column segment_name format a25 column segment_type format a25 select segment_name, segment_type, block_id, blocks from dba_extents where file_id = &file_no AND ( &block_value between block_id and ( block_id + blocks ) )
No comments:
Post a Comment