Exclude Compression Advisor Objects

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

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