My Oracle Support Banner

How To Resolve ORA-39166: Object ... Was Not Found Errors with Datapump Export / Import (Doc ID 2064408.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


This note helps you in resolving the ORA-39166: Object <OWNER>,<TABLE NAME> was not found errors with Data Pump export and import when using same parameter file for different loads.  

For example:  Having different tables in different databases and trying to use  the same par file for all the exports instead of creating different par file for each export

1.  The export parameter file looks similar to: 



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.