Oracle export scripts Example

exp.sh

#!/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