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.
Advertisements
Leave a Reply