DataPump Export Job With Large Table List Fails With ORA-39166
Last updated on MAY 03, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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:
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