Get the App
SLTechnology News&Howtos  ›  Database  › 

BUG occurs when impdp imports data

Shulou Source: shulou.com Published: 2022-06-01 13:43:44 11月13日 Update

An error occurred in importing data with the impdp data pump tool, and the import process was aborted unexpectedly. After checking the data on the Internet, it is found that this is a BUG of 11G, and the EXCLUDE=STATISTICS parameter needs to be added when importing.

Error prompt:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]

ORA-06502: PL/SQL: numeric or value error

LPX-00242: invalid use of ampersand ('&') character (use &)

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 9001

-PL/SQL Call Stack-

Object line object

Handle number name

0x916c7af0 20462 package body SYS.KUPW$WORKER

0x916c7af0 9028 package body SYS.KUPW$WORKER

0x916c7af0 16665 package body SYS.KUPW$WORKER

0x916c7af0 3956 package body SYS.KUPW$WORKER

0x916c7af0 9725 package body SYS.KUPW$WORKER

0x916c7af0 1775 package body SYS.KUPW$WORKER

0x93acfc98 2 anonymous block

Solution:

Add parameters to the EXCLUDE=STATISTICS-- impdp statement

Tags: Data parameters errors accidents tools methods statements data procedures this is plus prompt time out Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Microsoft Shulou Information Shulou Technology MySQL