DataPump Export Job With Large Table List Fails With ORA-39166

(Doc ID 2369777.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

With a large list in "TABLE" option in a parameter file, DataPump export job (expdp) starts to report ORA-39166 after unloading more then half of the specified tables:

...
28-JUL-17 16:50:02.194: Estimate in progress using BLOCKS method...
28-JUL-17 16:50:05.876: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
28-JUL-17 16:50:06.797:      Estimated 840 TABLE_DATA objects in 4 seconds
28-JUL-17 16:50:07.078: Total estimation using BLOCKS method: 52.5 MB
28-JUL-17 16:50:12.362: Processing object type TABLE_EXPORT/TABLE/TABLE
28-JUL-17 16:50:18.866:      Completed 840 TABLE objects in 11 seconds
28-JUL-17 16:50:20.068: . . exported "TC_USER1"."TAB1"                 5.046 KB       1 rows in 2 seconds
........
28-JUL-17 16:52:59.892: . . exported "TC_USER9"."TAB9"                 5.046 KB       1 rows in 0 seconds
28-JUL-17 16:53:04.689: ORA-39166: Object TC_USER22.TAB1 was not found or could not be exported or imported.
28-JUL-17 16:53:04.698: ORA-39166: Object TC_USER22.TAB2 was not found or could not be exported or imported.
28-JUL-17 16:53:04.705: ORA-39166: Object TC_USER22.TAB3 was not found or could not be exported or imported.
28-JUL-17 16:53:04.711: ORA-39166: Object TC_USER22.TAB4 was not found or could not be exported or imported.
...
28-JUL-17 16:53:08.852: ORA-39166: Object TC_USER38.TAB30 was not found or could not be exported or imported.
28-JUL-17 16:53:09.041:      Completed 840 TABLE_EXPORT/TABLE/TABLE_DATA objects in 161 seconds
28-JUL-17 16:53:09.792: Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded


DP traces show that all schemas from the parameter file were included:



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