Very very urgent - many invalid objects when upgraded from 220.127.116.11
Posted on 2003-12-12
I have upgraded from Oracle 18.104.22.168 to 22.214.171.124 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.