逻辑备份 命令

部份导出
exp userID/password@Instance file=E:\backup\WCDMA\WCDMA%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%.dmp owner=(WCDMA,WCDMA_ASSY,WCDMA_TSE)

全部导入
imp user/pwd@db_name full=y file=D:\database.dmp log=d:\impdatabase.log ignore=y

posted on 2010-06-21 11:20  ILoveDBA  阅读(296)  评论(0编辑  收藏  举报