How to fix the Oracle error ORA-39111: Dependent object type string skipped, base object type string already exists?

In this post, you’ll learn more about the Oracle ErrorORA-39111: Dependent object type string skipped, base object type string already exists with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39111: Dependent object type string skipped, base object type string already exists

Reason for the Error ORA-39111: Dependent object type string skipped, base object type string already exists

During a Data Pump import job, a dependent object is being skipped because its base object already existed.

How to fix the Error ORA-39111: Dependent object type string skipped, base object type string already exists ?

You can fix this error in Oracle by following the below steps

If the object from the dump file is wanted, drop the base and dependent objects and try to import again using desired filters.