WE ARE GOING TO SEE THE IMPORT FAILURE 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.

Posted by :  Sathiyaseelan

Recommended Posts

Start typing and press Enter to search