Oracle记录导入，导出对偶

AHSZY生成信息

Enterprise Manager Database Control URL - (orcl) :

http://itserver:1158/em

数据库配置文件已经安装到 D:/oracle/product/10.2.0,同时其他选定的安装组件也已经安装到 D:/oracle/product/10.2.0/db_1。

iSQL*Plus URL 为:

http://itserver:5561/isqlplus

iSQL*Plus DBA URL 为:

http://itserver:5561/isqlplus/dba

用户空间：

exp system/syitserver@ORCLE file=D:/oracle/back2009-4-2.dmp owner=(AHSZY)

imp SYSTEM/syitserver@ORCL file=D:/oracle/back2009-4-17.dmp log=D:/LOG.TXT fromuser=AHSZY

表：

exp AHSZY/syitserver@ORCL file=d:/WR_RLTW_C.dmp tables=(WR_RLTW_C)
     exp AHSZY/syitserver@ORCL file=d:/WS_SUMSL.dmp tables=(WS_SUMSL)

drop table WR_RLTW_C;drop table WS_SUMSL;

imp AHSZY/syitserver@ORCL file=d:/WR_RLTW_C.dmp tables=(WR_RLTW_C)
      imp AHSZY/syitserver@ORCL  file=d:/WS_SUMSL.dmp tables=(WS_SUMSL)

 

定时导出的批量语句：

@echo off 
for /f "tokens=2 delims==" %%a in ('wmic path win32_operatingsystem get LocalDateTime /value') do ( 
    set t=%%a 
) 
set Today=%t:~0,4%-%t:~4,2%-%t:~6,2% 
echo,%Today% 
exp INTERROGATE/INTERROGATE@ORCL file=D:/oraclebak/back%Today%.dmp owner=(INTERROGATE)