====== Oracle export scripts Example ======

  * exp.sh \\ <code bash>
#!/bin/sh
#
# starlits@adminschool.net
# Sun Jun 22 13:48:12 KST 2008
#

#exp system/oracle file=sit.dmp log=sit.log owner=sit

#######################################################
SYSTEM_USER="system"
SYSTEM_PASS="oracle"

LIST="
sit
scott
"
#######################################################

PROCDATE=`date +%Y%m%d_%H%M%S`

for user in $LIST ; do
    #echo $user
    echo "exp ${SYSTEM_USER}/${SYSTEM_PASS} file=${user}.${PROCDATE}.dmp log=${user}.${PROCDATE}.log owner=$user"
    exp ${SYSTEM_USER}/${SYSTEM_PASS} file=${user}.${PROCDATE}.dmp log=${user}.${PROCDATE}.log owner=$user
done


mkdir $PROCDATE
mv *${PROCDATE}.dmp *${PROCDATE}.log $PROCDATE
</code>