[code language=”sql”]

#!/bin/ksh
############################################################################
# Script Name..:
# Description..:
# Author…….: Michael Culp
# Date………: 04/ /2013
# Version……:
# Modified By..:
# Date Modified:
# Comments…..: You must have ASM parameters set for this to run properly
#              : A Diskgroup was setup called ACFS_DATA_DG01 to house the
#              : the new filesystems
# Schema owner.:
#    alter session set current
# Login User…:
# Run Order….:
# Dependent on.:
# Script type..:
#
############################################################################

sqlplus -s "/ as sysdba" <<EOF
set lines 150
set pages 150
— spool <some file name>

— col fs_name format a25
— col vol_device format a25

select segment_name
, blocks
, extents
from dba_segments
where segment_name in ( ‘SOMETABLE_01’, ‘SOMETABLE_02′ )
and owner =’MRCODS_OWNER’;

— spool off
EOF

[/code]