Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Downloaded compression Advisor from OTN does not wotk on Oracle 9.2.0.8

ebangma-Oracle
Member Posts: 121 Employee
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
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.