Error after PSCBO Installtaion
I have successfully completed PSCBO installation in our database. I have tried to gather STAT's on single table and worked as expected.
But after a week , I have tried to gather schema/table stat's on that database, I'm getting the below error.
*
ERROR at line 1:
ORA-04063: package body "PSADM.PSCBO_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PSADM.PSCBO_STATS"
ORA-06512: at line 1
Could someone help me to resolve as earliest.
Thnaks Karthick