Oracle Import Error ora-39126,ora-06502,lpx-00230

oracle11.2.0.4 IMPDP Error when importing the database

Import command:

IMPDP system/Cloud#osshk directory=data_pump_dir dumpfile=20180712.dmp logfile= 20180712. Log Schemas=xx,ss

Import error, error prompt as follows

 
 
 1 . . imported "WFM"."WO_SPEED_RECORD" 0 KB 0 rows
 2 . . imported "WFM"."WO_WIDTHBAND_SPEED_LOG" 0 KB 0 rows
 3 Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
 4 Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
 5 Processing object type SCHEMA_EXPORT/TABLE/COMMENT
 6 ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [COMMENT]
 7 ORA-06502: PL/SQL: numeric or value error
 8 LPX-00230: invalid character 60 (U+003C) found in a Name or Nmtoken
 9 
10 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
11 ORA-06512: at "SYS.KUPW$WORKER", line 9715
12 
13 ----- PL/SQL Call Stack -----
14 object line object
15 handle number name
16 0x9c7b75d30 21979 package body SYS.KUPW$WORKER
17 0x9c7b75d30 9742 package body SYS.KUPW$WORKER
18 0x9c7b75d30 17950 package body SYS.KUPW$WORKER
19 0x9c7b75d30 4058 package body SYS.KUPW$WORKER
20 0x9c7b75d30 10450 package body SYS.KUPW$WORKER
21 0x9c7b75d30 1824 package body SYS.KUPW$WORKER
22 0x9b6d68920 2 anonymous block
23 
24 ORA-39097: Data Pump job encountered unexpected error -1427
25 ORA-39065: unexpected master process exception in DISPATCH
26 ORA-01427: single-row subquery returns more than one row
27 
28 Job "SYSTEM"."SYS_IMPORT_SCHEMA_04" stopped due to fatal error at Thu Jul 12 15:08:49 2018 elapsed 0 00:00:30
 


	 

Workaround

Import comment is not imported. Use the following command to import the success

IMPDP system/Cloud#osshk directory=data_pump_dir dumpfile=20180712. DMP logfile = 20180712. Log Schemas=xx,ss EXCLUDE=Comment

Solution Ideas

When the import error, the general is to see in the import of what things reported the wrong, the 5th line of error message is in

Processing object type SCHEMA_EXPORT / TABLE / COMMENT

Then I just exclude the comment directly when importing, and think of other ways to regenerate the comment after the import is complete. 

Oracle Import Error ora-39126,ora-06502,lpx-00230