SOLVED

ORA-39126 ORA-06502 ORA-31605

Asked by fathy••46 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
the dump exported from oracle 19c and import to 11g when we imported the error below.

Import: Release 11.2.0.4.0 - Production on Tue Apr 21 17:52:28 2026

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_04":  system/******** directory=IMPDIR dumpfile=MORTGAGE1_tables.dmp logfile=MORTGAGE.log REMAP_SCHEMA=MORTGAGENEW:MOCKAPPS6 REMAP_TABLESPACE=users:FCRPROD_DDATA
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"MOCKAPPS6" already exists
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"MOCKAPPS6"."LEASE"]
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLProcessXML in routine kuxIntTransformXtoC:
LPX-321: None of the output method (DOM, SAX, Stream) is selected

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

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
700010ba484d3b0     21979  package body SYS.KUPW$WORKER
700010ba484d3b0      9742  package body SYS.KUPW$WORKER
700010ba484d3b0     17950  package body SYS.KUPW$WORKER
700010ba484d3b0      4058  package body SYS.KUPW$WORKER
700010ba484d3b0     10450  package body SYS.KUPW$WORKER
700010ba484d3b0      1824  package body SYS.KUPW$WORKER
700010b707abd38         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE:"MOCKAPPS6"."LEASE"]
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLProcessXML in routine kuxIntTransformXtoC:
LPX-321: None of the output method (DOM, SAX, Stream) is selected

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

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
700010ba484d3b0     21979  package body SYS.KUPW$WORKER
700010ba484d3b0      9742  package body SYS.KUPW$WORKER
700010ba484d3b0     17950  package body SYS.KUPW$WORKER
700010ba484d3b0      4058  package body SYS.KUPW$WORKER
700010ba484d3b0     10450  package body SYS.KUPW$WORKER
700010ba484d3b0      1824  package body SYS.KUPW$WORKER
700010b707abd38         2  anonymous block

Job "SYSTEM"."SYS_IMPORT_FULL_04" stopped due to fatal error at Tue Apr 21 17:52:30 2026 elapsed 0 00:00:01
##DUMP

Solutions(1)

1
2
add this option to the expdp command 
version=11
Mahmoud•

Post Your Solution