1. 确定 ORA-39166 的含义和上下文 ORA-39166 错误通常发生在尝试执行 Data Pump 导入(impdp)或导出(expdp)操作时,涉及到特定版本的兼容性或配置问题。具体来说,该错误表明在 Data Pump 操作中,指定的 'compatible' 参数值不被允许。 2. 查找官方文档或错误代码说明 Oracle 官方文档对 ORA-39166 的描述如下: ...
对手工创建expdp能够成功导出的S43_IDX$表和expdp导出提示ORA-39166报错的表对比dba_segments和dba_objects属性进行对比。发现dba_segments均无表相关信息(因为其为索引组织表,不存数据,所以dba_segments中无相关信息);但是,dba_objects属性对比发现expdp能够导出的表的dba_objects的secondary属性为N,而expdp导出提示ORA-...
ORA-39166:Object SYS.TEST was not found. ORA-31655:no data or metadata objects selected for job Job"SYS"."SYS_EXPORT_TABLE_01" completed with 2 error(s) atTue Nov 29 14:08:02 2022 elapsed 0 00:00:01 TEST表信息. SQL>show user USER is"SYS" SQL>select count(*) from test; COUNT...
Total estimation using BLOCKS method: 0 KB ORA-39166: Object SYS.TEST was not found. ORA-31655: no data or metadata objects selected for job Job "SYS"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Tue Nov 8 17:08:02 2022 elapsed 0 00:00:01 TEST表信息. SQL> show user USER...
问题描述:expdp导sys用户表时报错ORA-39166、ORA-31655,如下所示: [oracle@oel~]$ expdp \'/ as sysdba\' directory=DATA_PUMP_DIR dumpfile=test.dmplogfile=expdp.log tables=test Export:Release 11.2.0.4.0 - Production on Tue Nov 29 14:08:00 2022 ...
P9_A0_E5TABLE_EXISTS_ACTION=appendREMAP_SCHEMA=prdappo:MIG_TESTDATA_OPTIONS=SKIP_CONSTRAINT_ERRORSWith the Partitioning,OLAP,Data Mining and Real Application Testing optionsORA-39002:invalid operationORA-39166:ObjectMIG_TEST.MO1_MEMOwas not found.ORA-39164:PartitionMIG_TEST.MO1_MEMO:P9_A0_E5was...
impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 简介:今天在做imp和impdp的性能测试时,发现如果表中存在lob字段,加载真是慢的厉害,每秒钟大概1000条的样子,按照这种速度,基本上不用干活了。 比如5千万条记录,50000000/1000/60/60=13.89小时,时间是无法接受的。
翻看了一些文档,当impdp使用remap_schema时,导入dmp的所有数据时则不需要指定tables参数。 impdp username/password@ip/service_name REMAP_SCHEMA=user1:user2REMAP_TABLESPACE=data01:data02 directory=DPUMP DUMPFILE=RECORD.dmp job_name=job_JWXZZ cluster=N ...
ORA-39166: Object TEST.DEPT_EXT was not found. ORA-31655: no data or metadata objects selected for job Job "SYSTEM"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Thu Feb 26 18:37:21 2015 elapsed 0 00:00:01 Connecting as SYSTEM user, the one performing the export, the table...
EXPDP - ORA-39166 (Object Was Not Found) When Trying To Export The Data From A View (文档 ID 1640392.1) In this Document Symptoms Cause Solution References APPLIES TO: Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1] ...