Zero Row Exported And ORA-39166 During EXPDP (Doc ID 1269422.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2013***
***Checked for relevance on 02-May-2017***

Symptoms

EXPDP doesn't export rows from table that has rows, and fails with ORA-39166:

Export: Release 11.1.0.7.0 - Production on Friday, 01 October, 2010 10:59:38

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "TC"."SYS_EXPORT_TABLE_01":TC/******** directory=TEST_1 dumpfile=toto_test.dmp logfile=toto_test.log TABLES=(CI_ROOT_INSTR_K) REUSE_DUMPFILES=TRUE
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "TC"."CI_ROOT_INSTR_K" 0 KB 0 rows
ORA-39166: Object CI_ROOT_INSTR_K was not found.
Master table "TC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TC.SYS_EXPORT_TABLE_01 is:
D:\TARSR 3-2096781621\TOTO_TEST.DMP
Job "TC"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 11:00:40

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms