db : 10.2.0.4
os : x86_64 x86_64 x86_64 GNU/Linux
Issue : I just migrated db from 10.2.0.3 to 10.2.0.4.
Migration is successful. Registry is valid
COMP_ID VERSION STATUS
------------------------------ ------------------------------ --------------------------------------------
EXF 10.2.0.4.0 VALID
OWM 10.2.0.4.3 VALID
EM 10.2.0.4.0 VALID
CATALOG 10.2.0.4.0 VALID
CATPROC 10.2.0.4.0 VALID
JAVAVM 10.2.0.4.0 VALID
XML 10.2.0.4.0 VALID
CATJAVA 10.2.0.4.0 VALID
1 invalid object of sys found
--------------------------------------------------------------------------------------------------------------------------------
SYS
KUPW$WORKER
when I compiled the package got the following error
SQL> alter package KUPW$WORKER compile BODY;
Warning: Package Body altered with compilation errors.
SQL> SQL> show errors
Errors for PACKAGE BODY KUPW$WORKER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
15304/5 PL/SQL: SQL Statement ignored
15304/34 PL/SQL: ORA-00942: table or view does not exist
Any solution for this ?
how to find which table does not exist ?
Edited by: gln_gln_48@hotmail.com on Jun 12, 2009 3:22 PM