impdp导入Oracle数据库导出的数据
--复制备份文件至/backup/expdpbackup/
[oracle@localhost expdpbackup]$ cp /cjhx/appsoft/20200707_1703_iam_release.dmp /backup/expdpbackup/
--授权oracle用户可读写
[oracle@localhost expdpbackup]$ chown oracle:oinstall /backup/expdpbackup/20200707_1703_iam_release.dmp
--导入
impdp 'userid="/ as sysdba"' directory=DUMPDIR remap_schema=iam:tyqx191228 remap_tablespace=iam:tyqx191228,ibms:tyqx191228 dumpfile=20200707_1703_iam_release.dmp logfile=impdp_20200707_1703_iam_release.log table_exists_action=replace
说明：
1.如果源端用户与目标端用户不一致，使用remap_schema转换
2.如果源端表空间与目标端表空间不一致，使用remap_tablespace转换
数据库