Hi everyone,
Could you help me with this:
- After upgrading oracle 10.2.0.1 to 10.2.0.4, export with expdp shows the following error:
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('SYS',1,1,'10.01.00.02.00',newblock)
ORA-04063: package body "WMSYS.LTADM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTADM"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 906
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5419
...
Job "SYSTEM"."SYS_EXPORT_FULL_09" completed with 1 error(s) at 20:12:07
- After running utlrp.sql:
SQL> select text from dba_errors where name='LTADM';
TEXT
--------------------------------------------------------------------------------
PL/SQL: ORA-00980: synonym translation is no longer valid
PL/SQL: SQL Statement ignored
Thanks