[oracle@tewapdpwms11 ~]$ cat /home/oracle/DBA/bin/index_rebuild_GG.sh
#!/bin/bash
set +x
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1
export ORACLE_SID=seprwrp1
export PATH=/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/.local/bin:/home/oracle/bin:/u01/app/oracle/product/12.1.0.2/dbhome_1/bin

export LOG_FILE=/home/oracle/DBA/log/seprwrp1_index_rebuild_log_`date +%F%s.log`

sqlplus -s / as sysdba <<EOF >> $LOG_FILE
@/home/oracle/index_rebuild_check.sql
@/home/oracle/index_rebuild_AUTO_2.sql
@/home/oracle/index_rebuild_check.sql
EOF

chk_count=`grep "V_INDEXNAME" $LOG_FILE | wc -l`

if [ $chk_count -gt 0 ]; then
mailx -s "seprwrp1 : Index Rebuild details" Vinod.Siram@sephora.com < $LOG_FILE
fi

find /home/oracle/DBA/log -name 'seprwrp1_index_rebuild_log_*.log' -mmin +5 -exec rm -rf {} \;

exit

##Index rebuild for Golden Gate Database
05 10 * * 1,2,3,4,5,6 sh /home/oracle/DBA/bin/index_rebuild_GG.sh  1> /tmp/index_rebuild.txt 2> /tmp/index_rebuild.err