Database Utilities (MOSC)

MOSC Banner

Using Datapump API in ORACLE 11.2.0.3 getting ORA 39126 – worker unexpected fatal error in KUP$WORK

edited Mar 15, 2013 2:25AM in Database Utilities (MOSC) 2 commentsAnswered
 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',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center