Database DataWarehousing (MOSC)

MOSC Banner

Get_compression_ratio(advance) failed for indexes in12.1.0.2 RAC DB

edited Dec 11, 2014 10:03AM in Database DataWarehousing (MOSC) 1 commentAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center