using shell to login to oracle database as sysdba

17 15 * * 6 /export/home/oracle/ry/stats/analy_contact.sh > /export/home/oracle/ry/stats/analy_contact.log 2>&1

#!/bin/ksh
export ORACLE_SID=shsub
export ORACLE_HOME=/opt/app/oracle/product/11.2.0/11.2.0.4
cd /export/home/oracle/sv/
echo "Checking table size `date`"
${ORACLE_HOME}/bin/sqlplus "/ as sysdba" @zzt.sql
echo "Checking done `date`"


also

sqlplus -s "/ as sysdba" <<EOF

alter table hma_tm_prod_gen2_monitor.zzt_service_log drop partition zzt_service_log_2015$count update global indexes;

exit

EOF