사용자 도구

사이트 도구


dbms:oracle:admin:exp_script01

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