Very very urgent - many invalid objects when upgraded from 22.214.171.124
Posted on 2003-12-12
I have upgraded from Oracle 126.96.36.199 to 188.8.131.52 by applying the patchset
2632931. I tried to execute streams and it says DBMS_STREAMS_ADM_UTL,
DBMS_LOGMNR_D are invalid. I tried to recompile them but all in vain, they
dont get recompiled. When I executed the query "select
object_name,object_type from dba_objects where status='INVALID' and
owner='SYS';" it gives me a list of invalid objects. Please give me a
solution as its very urgent.
Thanks a lot in advance.