Data Continuity After CREATE or RENAME
To replicate DML operations on new Oracle tables resulting from a
CREATE
or RENAME
operation, the names of the
new tables must be specified in TABLE
and MAP
statements in the parameter files. You can use wildcards to make certain that they
are included.
To create a new user with CREATE USER
and then move new
or renamed tables into that schema, the new user name must be specified in
TABLE
and MAP
statements. To create a user
fin2
and move new or renamed tables into that schema, the
parameter statements could look as follows, depending on whether you want the
fin2
objects mapped to the same, or different, schema on the
target:
Extract:
TABLE fin2.*;
Replicat:
MAP fin2.*, TARGET different_schema
.*;