impdp user/password@db_name directory=data_pump_dir dumpfile=dump_name.dmp logfile=import.log
1、使用impdp命令导入dmp文件:
impdp user/password@db_name directory=data_pump_dir dumpfile=dump_name.dmp logfile=import.log
2、使用sqlplus导入dmp文件:
sqlplus user/password@db_name @import_script.sql
import_script.sql内容:
prompt Importing dump file ...
host imp userid=user/password@db_name file=dump_name.dmp log=import.log
prompt Import completed.