ORA-31655: no data or metadata objects selected for job

最新推荐文章于 2024-07-30 08:30:00 发布

原创最新推荐文章于 2024-07-30 08:30:00 发布 · 4.9k 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了使用Oracle的IMP工具进行数据库导入的过程，并详细记录了遇到的ORA-31655和ORA-39154错误及其解决方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@localhost ~]$ impdp aiki/aiki directory=dir dumpfile='togg.dmp' sqlfile=001.sql logfile=001.log

Import: Release 11.2.0.2.0 - Production on Fri Nov 29 00:37:05 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import
Master table "AIKI"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "AIKI"."SYS_SQL_FILE_FULL_01": aiki/******** directory=dir dumpfile=togg.dmp sqlfile=001.sql logfile=001.log

Job "AIKI"."SYS_SQL_FILE_FULL_01" successfully completed at 00:37:09