imp需要

 

导入全部：

imp user/password@10.10.10.10:1521/orcl file = C:\Users\Administrator\Desktop\20170404230000.dmp ignore = y full = y

 

导入单张表：

imp user/password@10.10.10.10:1521/orcl file = C:\Users\Administrator\Desktop\20170404230000.dmp ignore = y tables =(表名)

posted @ 2017-11-21 23:32  Alanf  阅读(189)  评论(0)  编辑  收藏  举报