Database Tuning (MOSC)

MOSC Banner

DBMS_COMPRESSION.get_compression_ratio ORA-00933 error

in Database Tuning (MOSC) 7 commentsAnswered ✓

Hi,

Trying to work out compression level for a large table but I am getting the following error when trying to run DBMS_COMPRESSION.get_compression_ratio.

Running Oracle Database 19c Enterprise Edition 19.11.

DECLARE

 2  l_blkcnt_cmp  PLS_INTEGER;

 3  l_blkcnt_uncmp PLS_INTEGER;

 4  l_row_cmp    PLS_INTEGER;

 5  l_row_uncmp   PLS_INTEGER;

 6  l_cmp_ratio   NUMBER;

 7  l_comptype_str VARCHAR2(32767);

 8 BEGIN

 9  DBMS_COMPRESSION.get_compression_ratio (

 10   scratchtbsname => 'HMF_STATIC',

 11   ownname     => 'BARB_2010',

 12   objname     => 'PN_PANELISATION_OUTPUT',

 13   subobjname   => NULL,

 14   comptype    => DBMS_COMPRESSION.comp_basic,

 15   blkcnt_cmp   => l_blkcnt_cmp,

 16   blkcnt_uncmp  => l_blkcnt_uncmp,

 17   row_cmp     => l_row_cmp,

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