0 Replies Latest reply on Feb 27, 2013 1:29 PM by ebangma-Oracle

    Downloaded compression Advisor from OTN does not wotk on Oracle 9.2.0.8

    ebangma-Oracle
      Allthough on OTN states that the compression advisor will work from Oracle 9i through 11g, the downloaded package does not compile in 9.2.0.8.0:

      SQL> ALTER PACKAGE SYS.DBMS_COMP_ADVISOR COMPILE;
      Warning: Package altered with compilation errors.

      SQL> select * from dba_errors;
      WNER                              NAME TYPE SEQUENCE LINE POSITION
      ------------------------------ ------------------------------ ------------ ---------- ---------- ----------
      TEXT
      ------------------------------------------------------------------------------------------------------------------------------------
      SYS DBMS_COMP_ADVISOR PACKAGE BODY 1 0 0
      PLS-00908: The stored format of DBMS_COMP_ADVISOR is not supported by this release

      SYS DBMS_COMP_ADVISOR PACKAGE BODY 2 21 2
      PLS-00707: unsupported construct or internal error [2702]


      Could you also please upload an 9.2.0 version of this package on OTN?

      Regards,
      Ed