How To Resolve ORA-39166: Object ... Was Not Found Errors with Datapump Export / Import
(Doc ID 2064408.1)
Last updated on OCTOBER 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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