Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- * expdp をcron 登録する
- ```expdp_oracle.sh
- #!/bin/sh
- export LANG=ja_JP.UTF-8
- export NLS_LANG=Japanese_Japan.AL32UTF8
- FILENM="expdp.dmp"
- LOG="expdp.log"
- DMP=$FILENM
- LOG=$LOG
- # expdp
- export ORACLE_BASE=/opt/oracle
- export ORACLE_HOME=/opt/oracle/product/12.1.0
- export ORACLE_SID=xxxx
- $ORACLE_HOME/bin/expdp xxxx/xxxx DIRECTORY=xxxx SCHEMAS=xxxx DUMPFILE=$DMP LOGFILE=$LOG
- ```
- ```
- $ crontab -l
- 8 12 * * * /home/oracle/expdp_oracle.sh >/tmp/analog.log 2>/tmp/analog-err.log
- ```
Add Comment
Please, Sign In to add comment