Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.