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
$ _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
반응형