Why is DataPump in 11g not smarter
rg2May 29 2009 — edited May 29 2009I am trying to run several data pump jobs in my 3 node rac env. On node 1 I have 2 impdp jobs running, and I would like to run 1 or 2 more on nodes 2 and nodes 3.
so here its
$ impdp user/****** parfile=USER.par
Import: Release 11.1.0.7.0 - 64bit Production on Friday, 29 May, 2009 8:36:50
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job IMP_USER for user USER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 736
ORA-39147: cannot migrate Data Pump queue table ownership to this instance
$ vi USER.par
DUMPFILE=USER.dmp
LOGFILE=imp_USER.log
DIRECTORY=DP_STAGING_DATA_01
TABLES=XYZ
CONTENT=DATA_ONLY
JOB_NAME=IMP_USER
DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS
This is all I found online.
Oracle Error : ORA-39147: cannot migrate Data Pump queue table ownership to this instance
Cause: 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.
Action: Start this job on the same instance where other active Data Pump jobs are running, or wait until they finish.
Anyone gotten around this?