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
HR
and move new or renamed tables into that schema, the
parameter statements could look as follows, depending on whether you want the
HR
objects mapped to the same, or different, schema on the
target:
Extract:
TABLE HR.*;
Replicat:
MAP HR.*, TARGET different_schema
.*;