DataPump Export Job With Large Table List Fails With ORA-39166
(Doc ID 2369777.1)
Last updated on JUNE 29, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document