I have various invalid scemas after applying a security patch .. i've been googling different cmds to re compile them, but not getting anywhere ..
I have tried running utlrp.sql but doesn't fix them and tried recompiling them individually .. but keep getting syntax errors
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
------------------------------------------------
DBMS_REPCAT_AUTH
MGMT_BSLN_INTERNAL
MGMT_BSLN
Please assist to rectify - thanks.
I have tried running utlrp.sql but doesn't fix them and tried recompiling them individually .. but keep getting syntax errors
SQL> SELECT OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
------------------------------------------------
DBMS_REPCAT_AUTH
MGMT_BSLN_INTERNAL
MGMT_BSLN
Please assist to rectify - thanks.