imp需要

导入全部:

imp user/password@10.10.10.10:1521/orcl file = C:UsersAdministratorDesktop20170404230000.dmp ignore = y full = y

导入单张表:

imp user/password@10.10.10.10:1521/orcl file = C:UsersAdministratorDesktop20170404230000.dmp ignore = y tables =(表名)

原文地址:https://www.cnblogs.com/Alanf/p/7875932.html