DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, June 28, 2018

Import fails with ORA-39126,ORA-06512,ORA-01403

Cause:

The issue happen when we migrate using export from 11gR2 windows and import it in 12cR2 Linux server.

Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"NOMU"."TIPOS_ACCON"]
ORA-01403: no data found

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6266

----- PL/SQL Call Stack -----
object line object
handle number name
c0000000da9e5770 14916 package body SYS.KUPW$WORKER
c0000000da9e5770 6293 package body SYS.KUPW$WORKER
c0000000da9e5770 12280 package body SYS.KUPW$WORKER
c0000000da9e5770 3278 package body SYS.KUPW$WORKER
c0000000da9e5770 6882 package body SYS.KUPW$WORKER
c0000000da9e5770 1259 package body SYS.KUPW$WORKER
c0000000da9cdf78 2 anonymous block


Solution:

The issue is due to trying to import all the schemas including sysman etc. Solution is to exclude all the system related schemas and import only the application schemas.

No comments: