Posted by Sathiyaseelan Mariappan
We are going to discuss about what makes the import fail in the below scenario.
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.