当前位置：Gxlcms > 数据库问题 > oracle impdp 出错 ORA-31655: no data or metadata objects selected for job ORA-39154:

oracle impdp 出错 ORA-31655: no data or metadata objects selected for job ORA-39154:

时间：2021-07-01 10:21:17 帮助过：7人阅读

impdp xxx/xxx@127.0.0.170/orcl directory=DPDATA dumpfile=20200623data.DMP full=y ;




Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from impor

-- 出现原因
原数据的schema 跟导入数据库不一样
-- 解决办法
加上

REMAP_SCHEMA=原账户schema:现在账户schema



impdp xxx/xxx@127.0.0.170/orcl directory=DPDATA dumpfile=20200623data.DMP full=y REMAP_SCHEMA=原账户schema:现在账户schema;


成功，记录下，怕自己忘了，网上看到的都是不是想要的

oracle impdp 出错 ORA-31655: no data or metadata objects selected for job ORA-39154:

标签：objects nbsp directory cts select tab bit sel ted

人气教程排行