Using Datapump API in ORACLE 11.2.0.3 getting ORA 39126 – worker unexpected fatal error in KUP$WORK
Hello
I'm wondering if anyone can help with a datapump api issue. I basically wrote a PL/SQL process that uses the datapump api to perform an schema level import from our "primary" database to a "staging" database. My environment
-ORACLE 11.2.0.3 (just patched from 11.2.0.1 also ran patches up to patch 13).
-Windows 2003 Server.
I can't directly post the code but from the example here my code will look very similar.
DECLARE
-- handle number comes with DBMS_DATAPUMP.OPEN procedure
n_dp_handle number;
BEGIN
n_dp_handle := DBMS_DATAPUMP.open(
operation=>'EXPORT',
job_mode=>'SCHEMA',
remote_link=>'dev2',
job_name=>'jobName1',
0