ORA-39166 & ORA-31655

喝醉酒的小白

已于 2022-07-19 21:43:00 修改

阅读量3.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： DBA 文章标签：数据库 dba oracle

于 2022-06-17 23:41:23 首次发布

本文链接：https://blog.youkuaiyun.com/hezuijiudexiaobai/article/details/125341722

DBA 专栏收录该内容

996 篇文章

订阅专栏

本文详细介绍了如何在SYS用户下执行导出操作时遇到的两个错误（oerrora39166和oerrora31655），包括错误原因、解决方案，以及创建用户和导出表的具体步骤。

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

问题

创建表到SYS用户下面导出报错

oerr ora 39166
39166, 00000, "Object %s was not found."
// *Cause:  If exporting or importing over the network,  either the user 
//          specified an object name that was not found in the source database 
//          or else the user lacked the proper EXP_FULL_DATABASE or 
//          IMP_FULL_DATABASE role that would allow them to access the object
//          another in another schema.  For importing from files, the user
//          specified an object name not found in the dump file set.
// *Action: Retry the operation using the correct object name.

oerr ora 31655
31655, 00000, "no data or metadata objects selected for job"
// *Cause:  After the job parameters and filters were applied, 
//          the job specified by the user did not reference any objects.
// *Action: Verify that the mode of the job specified objects to be moved.
//          For command line clients, verify that the INCLUDE, EXCLUDE and 
//          CONTENT parameters were correctly set.  For DBMS_DATAPUMP API 
//          users, verify that the metadata filters, data filters, and
//          parameters that were supplied on the job were correctly set.

解决方案

创建一个用户导出

create user jk identified by jk;
grant dba to jk;
conn jk/jk

expdp   \'sys/sys as sysdba\' DIRECTORY=DATA DUMPFILE=20220614.dmp =20220614.log TABLES=JK.GASH, JK.OBJ,JK.SQLSTAT