COL OWNER FORMAT A15
COL SEGMENT_NAME FORMAT A40
SET VERIFY OFF
SELECT
OWNER
,SEGMENT_NAME || DECODE(PARTITION_NAME, NULL, '', '('|| PARTITION_NAME ||')') SEGMENT_NAME
,SEGMENT_TYPE
,TABLESPACE_NAME
FROM DBA_EXTENTS
WHERE FILE_ID = &1.
AND &2. BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS -1
/
UNDEFINE 1
UNDEFINE 2