oracle 匯入報錯ORA-39126，ORA-06502，LPX-00230

標籤：ken   ora   tac   expect   rect   sch   job   style   font   

oracle11.2.0.4  impdp 匯入資料庫的時候報錯

匯入命令：

impdp system/Cloud#osshk directory=data_pump_dir dumpfile=20180712.dmp logfile=20180712.log  schemas=xx,ss  

匯入報錯，報錯提示如下

 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 9511 ORA-06512: at "SYS.KUPW$WORKER", line 971512 13 ----- PL/SQL Call Stack -----14 object line object15 handle number name16 0x9c7b75d30 21979 package body SYS.KUPW$WORKER17 0x9c7b75d30 9742 package body SYS.KUPW$WORKER18 0x9c7b75d30 17950 package body SYS.KUPW$WORKER19 0x9c7b75d30 4058 package body SYS.KUPW$WORKER20 0x9c7b75d30 10450 package body SYS.KUPW$WORKER21 0x9c7b75d30 1824 package body SYS.KUPW$WORKER22 0x9b6d68920 2 anonymous block23 24 ORA-39097: Data Pump job encountered unexpected error -142725 ORA-39065: unexpected master process exception in DISPATCH26 ORA-01427: single-row subquery returns more than one row27 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

 

解決方案

匯入的時候不匯入comment。使用如下命令即可匯入成功

impdp system/Cloud#osshk directory=data_pump_dir dumpfile=20180712.dmp logfile=20180712.log  schemas=xx,ss  EXCLUDE=comment

解決思路

匯入的時候報錯了，一般就是看在匯入什麼東西的時候報的錯，報錯資訊的第5行提示是在

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

那麼我在匯入的時候直接排除comment就好了，comment在匯入完成後想其他辦法重建吧。

oracle 匯入報錯ORA-39126，ORA-06502，LPX-00230