Exadata General (MOSC)

MOSC Banner

SAP BW - Exadata - Compress For OLTP

edited Jan 23, 2015 10:04AM in Exadata General (MOSC) 1 commentAnswered

anyone tried using the pack compression data to SAP BW tables?

When I try to estimate the gain space, the block below results in an error because the table name starting with "/ BIC / XX", it seems that does not accept that inicam table names with "/". Has anyone experienced this?

declare

lv_cmp_ratio number;

lv_comptype_str varchar2(300);

lv_BLKCNT_CMP number;

lv_BLKCNT_UNCMP number;

lv_ROW_CMP number;

lv_ROW_UNCMP number;

begin

dbms_compression.GET_COMPRESSION_RATIO(

SCRATCHTBSNAME=>'PSAPSR3',

OWNNAME=>'SAPSR3',

TABNAME=>'/BIC/XXXXXXXXXXXXXX',

PARTNAME =>null,

COMPTYPE =>2,

BLKCNT_CMP=>lv_BLKCNT_CMP,

BLKCNT_UNCMP=>lv_BLKCNT_UNCMP,

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