PLS-00302: component 'COMP_FOR_OLTP' must be declared

Question

I'm trying to execute compression script GET_COMPRESSION_RATIO from here: And this line gives me an error:

comptype => DBMS_COMPRESSION.comp_for_oltp,

PLS-00302: component 'COMP_FOR_OLTP' must be declared

In oracle documentation, they say "The DBMS_COMPRESSSION package is owned by user SYS, and must be created by SYS. The execution privilege is granted to PUBLIC. Subprograms in this package are executed using the privileges of the current user."

I granted PUBLIC role to my user but don't know how to create this package by SYS user. Or the problem lays somewhere else?

Answer 1

The terminology changed in 12c. See the constants here.

You could use DBMS_COMPRESSION.COMP_ADVANCED instead.

Answer 2

I was using wrong scripts for Oracle 11g. Correct ones for 12c can be found here.