Forum Stats

  • 3,839,358 Users
  • 2,262,486 Discussions
  • 7,900,950 Comments

Discussions

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
This discussion has been closed.