사용자 도구

사이트 도구


dbms:oracle:admin:exp_script01

문서의 이전 판입니다!


Oracle export scripts Example

#!/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
dbms/oracle/admin/exp_script01.1214116327.txt.gz · 마지막으로 수정됨: 2008/06/22 15:32 저자 starlits