How to fix the Oracle error ORA-39147: cannot migrate Data Pump queue table ownership to this instance?

In this post, you’ll learn more about the Oracle ErrorORA-39147: cannot migrate Data Pump queue table ownership to this instance with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-39147: cannot migrate Data Pump queue table ownership to this instance

Reason for the Error ORA-39147: cannot migrate Data Pump queue table ownership to this instance

There are active Data Pump jobs running on another instance in a RAC. All concurrent, active Data Pump jobs must be run on the same instance.

How to fix the Error ORA-39147: cannot migrate Data Pump queue table ownership to this instance ?

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

Start this job on the same instance where other active Data Pump jobs are running, or wait until they finish.