1 Reply Latest reply on Jan 29, 2012 5:43 AM by 864403

    Trying to run dbms_comp_advisor; creates with no errors but errors running

      Trying to run dbms_comp_advisor package; creates with no errors but errors running. Have tried to do as SYS and another user with DBA privileges and still same error. Oracle is 11gR2.

      And have got this error:

      SQL> CLCRT:TEST_COMP> set serveroutput on
      SQL> CLCRT:TEST_COMP> exec dbms_comp_advisor.getratio('CLARITY','table_name',25)
      BEGIN dbms_comp_advisor.getratio('CLARITY','table_name',25); END;

      ERROR at line 1:
      ORA-04067: not executed, package body "SYS.DBMS_COMP_ADVISOR" does not exist
      ORA-06508: PL/SQL: could not find program unit being called:
      ORA-06512: at line 1