Re: impdp Worker unexpected fatal error KUPW$WORKER.PUT_DDLS
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Wed, 28 Apr 2010 09:26:06 -0700 (PDT)
Message-ID: <bdfaf433-3f84-4298-9f02-339dcba83430_at_s41g2000vba.googlegroups.com>
On Apr 28, 10:54 am, feyd <admin...._at_gmail.com> wrote:
> I`m trying to import IMPDP, dump from (linux oracle 10.02.00.01.00) to
> oracle 11
> and i get :
>
> ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
> [TRIGGER:"SKASUJMNIE"."ADD_BS_CM"] ]
> ORA-06502: PL/SQL: numeric or value error
> LPX-00225: end-element tag "COLS_ITEM" does not match start-element
> tag "BODY"
>
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPW$WORKER", line 8164
>
> PL/SQL Call Stack
> object line object
> handle number name
> 0x112977a48 19028 package body SYS.KUPW$WORKER
> 0x112977a48 8191 package body SYS.KUPW$WORKER
> 0x112977a48 15631 package body SYS.KUPW$WORKER
> 0x112977a48 3944 package body SYS.KUPW$WORKER
> 0x112977a48 8874 package body SYS.KUPW$WORKER
> 0x112977a48 1651 package body SYS.KUPW$WORKER
> 0x11f7bee10 2 anonymous block
>
> it happens only where i import triggers ( include=triggers )
>
> file copy was made by scp (so i guess it binary mode ) , i think it
> occurs in metalink and it problem requires install patch.
>
> Is that any other way to read this trigger pl sql code from dmp file,
> using pl sql package or program such as awk or sed ?
Date: Wed, 28 Apr 2010 09:26:06 -0700 (PDT)
Message-ID: <bdfaf433-3f84-4298-9f02-339dcba83430_at_s41g2000vba.googlegroups.com>
On Apr 28, 10:54 am, feyd <admin...._at_gmail.com> wrote:
> I`m trying to import IMPDP, dump from (linux oracle 10.02.00.01.00) to
> oracle 11
> and i get :
>
> ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
> [TRIGGER:"SKASUJMNIE"."ADD_BS_CM"] ]
> ORA-06502: PL/SQL: numeric or value error
> LPX-00225: end-element tag "COLS_ITEM" does not match start-element
> tag "BODY"
>
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPW$WORKER", line 8164
>
> PL/SQL Call Stack
> object line object
> handle number name
> 0x112977a48 19028 package body SYS.KUPW$WORKER
> 0x112977a48 8191 package body SYS.KUPW$WORKER
> 0x112977a48 15631 package body SYS.KUPW$WORKER
> 0x112977a48 3944 package body SYS.KUPW$WORKER
> 0x112977a48 8874 package body SYS.KUPW$WORKER
> 0x112977a48 1651 package body SYS.KUPW$WORKER
> 0x11f7bee10 2 anonymous block
>
> it happens only where i import triggers ( include=triggers )
>
> file copy was made by scp (so i guess it binary mode ) , i think it
> occurs in metalink and it problem requires install patch.
>
> Is that any other way to read this trigger pl sql code from dmp file,
> using pl sql package or program such as awk or sed ?
What version of the expdp utility was used to make the export? And what version of the impdp utility are you trying to use to import the export?
Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions #553337.1
DataPump Import Including Statistics Terminates With Fatal Error ORA-39126, ORA-6502, LPX-225 End-Element Tag "HIST_GRAM_LIST_ITEM" #878626.1
There are numerous other problem reports that you may want to check out on Oracle support.
HTH -- Mark D Powell -- Received on Wed Apr 28 2010 - 11:26:06 CDT