SQLPLUS_RET=$?
if [ ${SQLPLUS_RET} -eq 0 ]; then
echo "NOTE: Data exporting succeeded without error !" >> $logfile
else
echo "ERROR at step 2: Data exporting executing failed !"
exit 1
fi
sqlplus sys/${DB_SYS_PASSWD} as sysdba @create_temp_folder.sql
SQLPLUS_RET=$?
if [ ${SQLPLUS_RET} -eq 0 ]; then
echo "NOTE: directory was created successfully without error!"
else
echo "ERROR at step 1: Create directory executing failed"
exit 1
fi