This section provides instructions for adding a supported object to replication, or changing the specifications of an object, while replication is active.
Note: To add sequences to replication, see Add Oracle sequences to an active replication configuration.
If you are using wildcards and an object that you are adding satisfies the wildcard specification, it is not necessary to add the object to the configuration file if the source is Oracle. Any new objects that match the wildcard criteria are automatically added into replication. Only add objects that must be explicitly stated by name.
Important! Do not deactivate the original configuration.
In sp_ctrl, issue the copy config command to make a copy of the active configuration file.
sp_ctrl> copy config filename to newname
Where: filename is the name of the active file and newname is the name of the new one.
Issue the edit config command to open the new configuration file in the default text editor.
sp_ctrl> edit config newname
Add the entries for the new tables or change existing entries.
Note: To change partitioned replication, see Change Partitioned Replication.
Activate the new configuration. This deactivates the original configuration. Only the new or changed tables are activated, so the activation should not be as long as the initial activation.
sp_ctrl> activate config newname