Oracle12 数据库脚本导入导出（包含表结构、表数据、触发器、视图）博客园

 

导入

impdp USERID=c##erchtms_GDHJB/1234/1234@orcl REMAP_SCHEMA=erchtms_GDHJB:BIEOS_HRCZ_HGAQ directory=dump_dir dumpfile=erchtms_GDHJB.DMP
@pause

 

--导出

EXPDP USERID=c##erchtms_GDHJB/1234@orcl schemas=c##erchtms_GDHJB directory=dump_dir dumpfile=erchtms_GDHJB.dmp logfile=erchtms_GDHJB.log
pause

 

--注意事项

select * from all_directories ;
create or replace directory dump_dir as 'F:\orcl\admin\orcl\dpdump'