Need help on impdp via network_link of non-system,non-application tables
BinoyJan 30 2011 — edited Feb 2 2012Hi,
I am trying to impdp via network_link of non-system,non-application tables and is having the following errors:
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-02041: client database did not begin a transaction
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
----- PL/SQL Call Stack -----
object line object
handle number name
0x629ba128 19208 package body SYS.KUPW$WORKER
0x629ba128 8385 package body SYS.KUPW$WORKER
0x629ba128 12748 package body SYS.KUPW$WORKER
0x629ba128 4742 package body SYS.KUPW$WORKER
0x629ba128 9110 package body SYS.KUPW$WORKER
0x629ba128 1688 package body SYS.KUPW$WORKER
0x6c54d1c8 2 anonymous block
Job "SYSADM"."IMP_USERS" stopped due to fatal error at 12:01:39
Here is my parfile:
NETWORK_LINK=DBLINK
FULL=Y
PARALLEL=8
EXCLUDE=SCHEMA:"IN ('SYS','SYSTEM','OUTLN','PS','SYSADM','DBSNMP','PEOPLE','DIP','ORACLE_OCM','CSMIG','PSMON','PERFSTAT'"
JOB_NAME=IMP_USERS
Please let me know if you know need any more details other than the ones provided above. the source is an 11gr2 on RHEL5 pulling data from 10204 on HP_UX.
Edited by: Binoy on Feb 10, 2011 8:35 AM