ORACLE/SCRIPT

oracle 날짜 넣어서 익스포트 받기

[PineTree] 2010. 11. 24. 14:43
반응형
## for unix
$ _DATE=`date +%y%m%d`
$ _DIR=/data/exp
$ exp asd/asd@asd file = ${_DIR}/file_name_${_DATE}.dmp

## for window
c:\> exp asd/asd@asd file = file_name_"%DATE%".dmp

#################################################################################
crontab 설정 파일

#!/bin/bash
datetime=$(date +%Y%m%d)

exp mediasp/mediasp file="/backup/phoenix/phoenixdb_$datetime.dmp" log="/backup/phoenix/phoenixdb_$datetime.log" full=y direct=y


반응형