Downloaded compression Advisor from OTN does not wotk on Oracle 9.2.0.8
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