#!/bin/ksh
export ORACLE_SID=MYSID
export ORACLE_HOME=/home/oracle/product/8.1.6
        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', 'OPDE', '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', 'OPDE2');
   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