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

最新推荐文章于 2023-02-14 13:14:28 发布

mhabbyo

最新推荐文章于 2023-02-14 13:14:28 发布

阅读量3.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE

本文链接：https://blog.youkuaiyun.com/mhabbyo/article/details/84617996

ORACLE 专栏收录该内容

10 篇文章

订阅专栏

本文记录了一次使用Oracle数据库导入导出工具impdp进行数据导入的过程。详细展示了如何通过指定目录、dump文件及表空间来进行数据导入，并成功完成作业。

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

[oracle@test scripts]$ impdp "'/ as sysdba'" DIRECTORY=data_back DUMPFILE=TEST_INFAREP.dmp TABLESPACES=TEST_INFAREP

Import: Release 11.2.0.4.0 - Production on Thu Nov 29 10:22:43 2018

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31655: no data or metadata objects selected for job
Master table "SYS"."SYS_IMPORT_TABLESPACE_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_TABLESPACE_01": "/******** AS SYSDBA" DIRECTORY=data_back DUMPFILE=TEST_INFAREP.dmp TABLESPACES=TEST_INFAREP
Job "SYS"."SYS_IMPORT_TABLESPACE_01" successfully completed at Thu Nov 29 10:22:45 2018 elapsed 0 00:00:01

impdp "'/ as sysdba'" DIRECTORY=data_back DUMPFILE=TEST_INFAREP.dmp remap_schema=users:TEST_INFAREP