PLS-00302: component 'COMP_FOR_OLTP' must be declared I'm trying to execute compression script GET_COMPRESSION_RATIO from here: 
And this line gives me an error: 

comptype =&gt; 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?
The terminology changed in 12c. See the constants here.

You could use DBMS_COMPRESSION.COMP_ADVANCED instead.