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