ORA-39166 & ORA-31655

本文详细介绍了如何在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 
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值