Oracle导入导出实例

在命令行cmd中

导入
imp soprompmf/soprompmf file=c:\soprompmf_backup\soprompmf2013-10-21.dmp log=c:\soprompmf_backup\2013-10-21 full=y ignore=y


导出
rem get yyyy
set yyyy=%date:~0,4%
rem get mm
set mm=%date:~5,2%
rem get dd
set dd=%date:~8,2%
set mydate=%yyyy%-%mm%-%dd%
exp soprompmf/soprompmf@orcl9i file=c:\soprompmf_backup\soprompmf%mydate%.dmp log=c:\soprompmf_backup\soprompmf%mydate%.log compress=y direct=n rows=y owner='soprompmf' consistent=n constraints=y grants=y indexes=y triggers=y


导出远程oracle
exp loan/loan@192.168.0.1:1521/testdb file=c:\soprompmf_backup\soprompmf%mydate%.dmp log=c:\soprompmf_backup\soprompmf%mydate%.log compress=y direct=n rows=y owner='loan' consistent=n constraints=y grants=y indexes=y triggers=y