Home > ORA-XXX > ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] ORA-06502: PL/SQL: numeric or value error LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] ORA-06502: PL/SQL: numeric or value error LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

When I imported db dump by impdp,  just go to the end of importing process, it showed errors below

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 7839

—– PL/SQL Call Stack —–
object      line  object
handle    number  name
3acdf1c68     18237  package body SYS.KUPW$WORKER
3acdf1c68      7866  package body SYS.KUPW$WORKER
3acdf1c68     15147  package body SYS.KUPW$WORKER
3acdf1c68      3792  package body SYS.KUPW$WORKER
3acdf1c68      8532  package body SYS.KUPW$WORKER
3acd5b510         1  anonymous block
3ae12d930      1575  package body SYS.DBMS_SQL
3acdf1c68      8342  package body SYS.KUPW$WORKER
3acdf1c68      1545  package body SYS.KUPW$WORKER
3acdf3ca0         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 7839

—– PL/SQL Call Stack —–
object      line  object
handle    number  name
3acdf1c68     18237  package body SYS.KUPW$WORKER
3acdf1c68      7866  package body SYS.KUPW$WORKER
3acdf1c68     15147  package body SYS.KUPW$WORKER
3acdf1c68      3792  package body SYS.KUPW$WORKER
3acdf1c68      8532  package body SYS.KUPW$WORKER
3b2278490         1  anonymous block
3ae12d930      1575  package body SYS.DBMS_SQL
3acdf1c68      8342  package body SYS.KUPW$WORKER
3acdf1c68      1545  package body SYS.KUPW$WORKER
3acdf3ca0         2  anonymous block

Job “SYS”.”SYS_IMPORT_FULL_02″ stopped due to fatal error at 19:48:10

Solution

To workaround this issue, repeat e impdp using the parameter EXCLUDE=STATISTICS as below

1. $ impdp \’/ as sysdba\’ parfile=imp_05Feb2013.par exclude=statistics

2. SQL> exec dbms_stats.gather_database_stats(estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE);

Advertisements
Categories: ORA-XXX
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: