Adding new objects to replication

Adding new tables or adding new schemas

Once the replication has been configured and is running, new objects can be added to the replication using the PREPARE command. Steps you need to take to add a new object differ whether you are running one-way or two-way replication. Please see details below for more info on adding new objects.

If a whole schema is replicated, then new tables in the source database will automatically be created in the target database (This applies for the Oracle target databases only).

Please check the child pages for details.