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:
Sequences with the CYCLE
attribute cannot be replicated.