REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_db_seg_where.sql
REM
REM <SQLDIR_GRP>TAB INDX SEGMENT STORAGE</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	THIS Script reports table or index extent maping by datafile.
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_db_seg_where.sql <TABLE_OR_INDEX_NAME> <OWNER>
REM 
REM Example:
REM	s_db_seg_where.sql SCOTT_INDEX SCOTT
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

set lines 132
col segment_name format a15
col segment_type format a10
col file_name    format a35
col kbytes       format 999,999,999.99

break on report
compute sum of kbytes on report

select de.segment_name
,      de.segment_type
,      ddf.file_name
,      de.bytes/1024 kbytes
,      de.blocks
from   dba_extents    de
,      dba_data_files ddf
where  de.segment_name = '&table_or_index_name'
and    de.owner = '&owner'
and    de.file_id = ddf.file_id
/