List an Object and Object Type via a Given File and Block ID.
--
-- List an Object and Object Type via a Given File and Block ID.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
COLUMN segment_name FORMAT A24
COLUMN segment_type FORMAT A24
 
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 ) )
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License