#!/bin/ksh
# To unload BIJU tables which are not part of EXPORT
# 
# Biju Thomas - 04/21/99
#
#
export ORACLE_SID=MYSID
export ORACLE_HOME=`find_ohome.sh ${ORACLE_SID}`
        export SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib
        export TMPDIR=/tmp
        export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#
wlogfile=unload.${ORACLE_SID}
SQLPLUS=${ORACLE_HOME}/bin/sqlplus
echo "Start time : "`date` > $wlogfile
$SQLPLUS -s /  >> $wlogfile <<EOF
   set echo off feedback off pages 0
   SET TRANSACTION READ ONLY;

   PROMPT BEGIN UNLOAD TABLE MY_PERS_TABLE
   SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM dual;
   EXECUTE TABLE_UNLOAD('MY_PERS_TABLE', 'BIJU', 'PK_MY_PERS_TABLE');
   PROMPT END UNLOAD TABLE MY_PERS_TABLE
   SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM dual;

   PROMPT BEGIN UNLOAD TABLE MY_SECOND
   SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM dual;
   EXECUTE TABLE_UNLOAD('MY_SECOND', 'BIJU2');
   PROMPT END UNLOAD TABLE MY_SECOND
   SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM dual;

EOF
wc -l /ora_backup/demodb/*.dat >> $wlogfile
echo "Compress data files..." >> $wlogfile
compress -f /ora_backup/demodb/*.dat 2>> $wlogfile
echo "End time : "`date` >> $wlogfile
#
# End of script