EXPDP FAILS WITH ORA-39126: KUPW$WORKER.UNLOAD_METADATA [OBJECT_GRANT:”SYSTEM”] Worker unexpected fatal error ORA-06512: at “SYS.KUPW$WORKER”, line 7839

Problem:

ORA-39126: KUPW$WORKER.UNLOAD_METADATA [OBJECT_GRANT:"SYSTEM"] Worker unexpected fatal error
ORA-06512: at "SYS.KUPW$WORKER", line 7839

Solution:1) –Take your own risk!!

exec dbms_stats.delete_database_stats;

exec dbms_stats.gather_database_stats;

2) If deleting and gathering stats do not work, exclude indexes and statistics in expdp if possible. 3) If your problem persists, try this:

select * from dba_indexes
where (owner, index_name) in
(select c.name, b.name
from ind$ a, obj$ b, user$ c
where to_char (a.spare6, 'DD-MON-YY') ='00-000-00' and
b.obj# = a.obj# and c.user# = b.owner#);

SQL> UPDATE IND$ SET SPARE6 = SYSDATE WHERE TO_CHAR (SPARE6, 'DD-MON-YY') ='00-000-00';
SQL> COMMIT;

4) or you can try this:

declare

n1 number;
n2 number;
n3 date;
begin
for i in (
SELECT OBJ#, DATAOBJ#,spare6
spare6 FROM SYS.IND$)
loop
n1:=i.OBJ#;
n2:=i.DATAOBJ#;
n3:=i.spare6;
dbms_output.put_line(to_char(n3,'dd/mm/yyyy'));
end loop;
exception
when others then
dbms_output.put_line(n1||'-'||n2);
end;
/

Drop and create problematic indexes in dbms output.