Exclude Compression Advisor Objects

Problem Description

This article explains how to exclude the compression advisor objects while setting up replication. This articles is applicable only for customers using version below 2.7

Solution

In the current version you can use the EXCLUDE table command in the dbvrep script before running

*-all.sh script to ignore the tables created by Oracle Compression Advisor:

EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_UNCMP                 
EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_CMP                   
SET PREPARE_SCHEMA_EXCEPTIONS DBMS_TABCOMP_TEMP_UNCMP,EX_%

In Dbvisit Replicate 2.7 you can specify tables to be excluded in the setup wizard.

Donna Zehl May 30, 2014 04:51

Knowledge Base Dbvisit Replicate

Exclude Compression Advisor Objects

Analytics

Related content