SAP BW - Exadata - Compress For OLTP
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,