June 11, 2012

IMPDP failed with “ORA-06502 character string buffer too small”

Today, when performing an impdp task, i got below error:

Starting "SYSTEM"."SYS_IMPORT_FULL_03":  system/********
dumpfile=part09_10_data%U.dmp logfile=imp_part.log
REMAP_table=swxxxdm.T_SWP_XXXTTT_TRAIL:swxxxdm.T_SWP_XXXTTT_TRAIL_PAR 
directory=exppart table_exists_action=append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [16]
TABLE_DATA:"SWAPADM"."SWAPADM.T_SWP_XXXTTT_TRAIL_PAR"
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9007

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x91a7ad90     20462  package body SYS.KUPW$WORKER
0x91a7ad90      9028  package body SYS.KUPW$WORKER
0x91a7ad90     20024  package body SYS.KUPW$WORKER
0x91a7ad90      4117  package body SYS.KUPW$WORKER
0x91a7ad90      9725  package body SYS.KUPW$WORKER
0x91a7ad90      1775  package body SYS.KUPW$WORKER
0x77cceb30         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [16]
TABLE_DATA:"SWAPADM"."SWAPADM.T_SWP_XXXTTT_TRAIL_PAR"
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 9007

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x91a7ad90     20462  package body SYS.KUPW$WORKER
0x91a7ad90      9028  package body SYS.KUPW$WORKER
0x91a7ad90     20024  package body SYS.KUPW$WORKER
0x91a7ad90      4117  package body SYS.KUPW$WORKER
0x91a7ad90      9725  package body SYS.KUPW$WORKER
0x91a7ad90      1775  package body SYS.KUPW$WORKER
0x77cceb30         2  anonymous block

Job "SYSTEM"."SYS_IMPORT_FULL_03" stopped due to fatal error at 23:47:11

After checking, find the reason is because below part:
REMAP_table=swxxxdm.T_SWP_XXXTTT_TRAIL:swxxxdm.T_SWP_XXXTTT_TRAIL_PAR

After i removed schema name, change it to:
REMAP_table=T_SWP_XXXTTT_TRAIL:T_SWP_XXXTTT_TRAIL_PAR

And then re-run the impdp succeed without errors.

0 Comments:

Post a Comment