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 new 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
.*;