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?
Best Answer
The terminology changed in 12c. See the constants here.
You could use
DBMS_COMPRESSION.COMP_ADVANCEDinstead.