Hi Team,
Source Oracle 10G 10.2.0.3.0
Target oracle 12c 12.1.0.2.0
can anyone help on this?
when I run the following command, file are getting exported without any issue
expdp system/system123 schemas=testing directory=exp_dir1 dumpfile=test_%U.dmp logfile=test.log network_link=BPRDR_HP2 exclude=statistics
but when I add on parallel run, then give me following issue.
expdp system/welcome1 schemas=testing directory=exp_dir1 dumpfile=test_%U.dmp logfile=test.log network_link=BPRDR_HP2 exclude=statistics filesize=200M parallel=4
Export: Release 12.1.0.2.0 - Production on Mon May 23 11:45:55 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_12": system/******** schemas=testing directory=exp_dir1 dumpfile=test_%U.dmp logfile=test.log network_link=BPRDR_HP2 CONTENT=DATA_ONLY exclude=statistics filesize=200M parallel=4
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.044 GB
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN []
ORA-06550: line 1, column 13:
PLS-00352: Unable to access another database 'BPRDR_HP2'
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_DATAPUMP@BPRDR_HP2' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 11254
----- PL/SQL Call Stack -----
object line object
handle number name
0x2d7929150 27116 package body SYS.KUPW$WORKER
0x2d7929150 11286 package body SYS.KUPW$WORKER
0x2d7929150 2135 package body SYS.KUPW$WORKER
0x28740ea30 2 anonymous block
JOB VERSION: 10.2.0.3.0
ACCESS METHOD: AUTOMATIC
DATA OPTIONS: 0
DUMPER DIRECTORY: NULL
REMOTE LINK: BPRDR_HP2
TABLE EXISTS : NULL
PARTITION OPTIONS: NONE
KUPF$FILE.TERM
KUPF$FILE.TERM
In procedure DETERMINE_FATAL_ERROR with ORA-06550: line 1, column 13:
PLS-00352: Unable to access another database 'BPRDR_HP2'
ORA-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_DATAPUMP@BPRDR_HP2' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Job "SYSTEM"."SYS_EXPORT_SCHEMA_12" stopped due to fatal error at Mon May 23 11:46:00 2016 elapsed 0 00:00:04
any can advice ?
Thanks so much!!