Including or Excluding Database Objects from Replication

An active standby pair replicates an entire database by default. Use the INCLUDE clause to replicate only the tables, cache groups, and sequences that are listed in the INCLUDE clause. No other database objects are replicated in an active standby pair that is defined with an INCLUDE clause.

For example, this INCLUDE clause specifies three tables to be replicated by the active standby pair:

INCLUDE TABLE employees, departments, jobs

You can choose to exclude specific tables, cache groups, or sequences from replication by using the EXCLUDE clause of the CREATE ACTIVE STANDBY PAIR statement. Use one EXCLUDE clause for each object type. For example:

EXCLUDE TABLE ttuser.tab1, ttuser.tab2
EXCLUDE CACHE GROUP ttuser.cg1, ttuser.cg2
EXCLUDE SEQUENCE ttuser.seq1, ttuser.seq2

Note:

When including (or excluding) a log-based cache group, you must also include (or exclude) the checkpoint tables used to track the SCN of the cache group in Oracle GoldenGate. The name of these tables are user-defined, see Oracle GoldenGate Checkpoint Tables in Oracle Database Administering Oracle GoldenGate Classic Architecture.

INCLUDE TABLE ttuser.tt_chkp
INCLUDE TABLE ttuser.tt_chkp_lox

See About Log-Based and Trigger-Based Read-Only Cache Groups in Oracle TimesTen In-Memory Database Cache Guide.

Note:

Sequences with the CYCLE attribute cannot be replicated.