After upgrading the databases from 11.2.0.3 to 11.2.0.4 the QUEST_SPC_ANALYZE package becomes invalid and will not compile. The error given is line 1068 of the package body column 12 PLS-00201 QUEST_SPC_IND_COL_HIST must be declared.
Error desc:
PLS-00201: identifier 'QUEST_SPC_IND_COL_HIST' must be declared
Grant select privileges to sys.hist_head$ table.
Here is the complete syntax:
SQL>grant select privilege on sys.hist_head$ to <Space Manager Schema>;
Here are some more things to know:
The granting of privilege will not make the package <owner>..QUEST_SPC_ANALYZE valid. One way to make it valid is to either compile it, or it will be recompiled once the Space Manager program runs and calls this package.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center