read tablename
case $tablename in
$tablename )
echo "켾E~L뼾]´뷾T 뼾]´륾D뼾]~D 뼾^~E깼 ¥켾U~X뼾D¸뼾Z~T"
#read tablename
sqlplus -s /nolog <<EOF23
conn / as sysdba
set head off
set line 200
spool /home/oracle/index.sh
select a.table_name, b.index_name, c.partition_name,
c.tablespace_name,
round(c.bytes/1024/1024,0), c.extents,
round(c.initial_extent/1024/1024,0),
round(c.next_extent/1024/1024,0)
from user_tables a, user_indexes b, user_segments c
where a.table_name = b.table_name(+)
and b.index_name = c.segment_name(+)
and b.table_name = :$tablename
order by table_name, index_name, partition_name ;
spool off
set head on
set feedback on
exit
EOF23
;;
esac
exit 0
바인드 변수를 케이스문안에 사용해서
입력받은 테이블 인덱스를 조회하려하는데
안되네요
문법적으로 원래 실행이 안되는 것인지 궁금합니다..