로아

일자 로우로 출력

SELECT TO_CHAR(TO_DATE('{시작일자}', 'YYYYMMDD')+LEVEL-1, 'YYYY-MM-DD')
  FROM DUAL
CONNECT BY LEVEL <= (TO_DATE('{종료일자}', 'YYYYMMDD')-TO_DATE('{시작일자}', 'YYYYMMDD')+1)

오라클 덤프 스케줄

Windows

expdp system/oracle directory=DUMP dumpfile=full_expdp_%DAY%.dmp logfile=full_expdp_%DAY%.log full=y

forfiles -p "D:\oraclebackup\dump" -s -m ** /D -30 /C "cmd /c del @path"

Linux

find /data/backup/ -name "*.dmp" -mtime +7 -exec rm {} \;

find /data/backup/ -name "*.log" -mtime +7 -exec rm {} \;

export NLS_LANG=KOREAN_KOREA.KO16MSWIN949
exp DWS/DWS0330@DWS FILE=/data/backup/DWS_exp`date +%y%m%d`.dmp LOG=/data/backup/DWS_exp`date +%y%m%d`.log GRANTS=Y INDEXES=Y ROWS=Y CONSTRAINTS=Y TRIGGERS=Y COMPRESS=N DIRECT=N CONSISTENT=Y OWNER=DWS