oracle导出脚本文件怎么打开,Oracle exp/expdp 导出脚本

1、window exp

@echo off

rem 指定文件的存放路径

set SrcDir=e:\oracle_bak

rem 指定文件名

set filename="%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%"

rem 导出数据

exp xxx/xxx@192.168.xxx.xxx/xxx directory=dpfile file=%SrcDir%\xxx_%filename%.dmp log=%SrcDir%\xxx_%filename%.log

rem 指定保留天数

set DaysAgo=7

rem 删除过期文件

forfiles /p %SrcDir% /s /m *.dmp /d -%DaysAgo% /c "cmd /c del /f /q /a @path"

2、window expdp

@echo off

rem 指定文件名

set filename="%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%"

rem 导出数据

expdp xxx/xxx@192.168.xxx.xxx/xxx directory=xxx dumpfile=xxx_%filename%.expdmp logfile=xxx_%filename%.log

rem 指定待删除文件的存放路径

set SrcDir=e:\oracle_bak

rem 指定保留天数

set DaysAgo=7

rem 删除过期文件

forfiles /p %SrcDir% /s /m *.expdmp /d -%DaysAgo% /c "cmd /c del /f /q /a @path"

3、linux exp

#!/bin/bash

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export NLS_LANG=american_america.zhs16gbk

export PATH=$ORACLE_HOME/bin:$PATH

#begin

DUMP=/home/oracle/backup

FILE=`date +%Y%m%d%H%m%S`

exp xxx/xxx@192.168.xxx.xxx/xxx dump=$DUMP/xxx_$FILE.exp log=$DUMP/xxx_$FILE.log

#del old backfile

find $DUMP -name "*.exp" -mtime +7 -exec rm {} \;

find $DUMP -name "*.log" -mtime +7 -exec rm {} \;

4、linux expdp

#!/bin/bash

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export NLS_LANG=american_america.zhs16gbk

export PATH=$ORACLE_HOME/bin:$PATH

#begin

FILE=`date +%Y%m%d%H%m%S`

expdp xxx/xxx@192.168.xxx.xxx/xxx directory=xxx dumpfile=xxx_$FILE.expdmp logfile=xxx_$FILE.log

#del old backfile

DUMP=/home/oracle/backup

find $DUMP -name "*.expdmp" -mtime +7 -exec rm {} \;

find $DUMP -name "*.log" -mtime +7 -exec rm {} \;