Get_compression_ratio(advance) failed for indexes in12.1.0.2 RAC DB
I ran get_compression_ratio for indexes in my12.1.0.2 databases and it failed with the below error.
SQL> DECLARE
2 blkcnt_cmp pls_integer;
3 blkcnt_uncmp pls_integer;
4 row_cmp pls_integer;
5 row_uncmp pls_integer;
6 cmp_ratio pls_integer;
7 comptype_str varchar2(100);
8 BEGIN
9 DBMS_COMPRESSION.GET_COMPRESSION_RATIO
10 (
11 scratchtbsname => 'TBSP_INDEX',
12 ownname => 'SCOTT',
13 objname => 'NAME_CMP1_IX',
14 subobjname => NULL,
15 comptype => dbms_compression.COMP_INDEX_ADVANCED_LOW,
16 blkcnt_cmp => blkcnt_cmp,
17 blkcnt_uncmp => blkcnt_uncmp,
18 row_cmp => row_cmp,
19 row_uncmp => row_uncmp,
20 cmp_ratio => cmp_ratio,
21 comptype_str => comptype_str,
22 subset_numrows => dbms_compression.COMP_RATIO_MINROWS,
23 objtype => dbms_compression.OBJTYPE_INDEX