Description

The DR TABLE statement identifies a table as a participant in database replication (DR). If DR is not enabled, the DR TABLE statement has no effect on the operation of the table or the database as a whole. However, once DR is enabled, the results of any updates to the contents of DR tables are sent to the associated XDCR clusters.

The DR TABLE ... DISABLE statement reverses the effect of a previous DR TABLE statement, removing the specified table from participation in DR. The databases must be paused when you issue the DR TABLE... DISABLE command and you must apply it to all participating clusters before resuming operation. The DR TABLE command cannot be used with dynamic schema change.

See Chapter 11, Active(N) Database Replication for more information about how database replication works and Section 11.3.1, “Safely Updating the Schema While the Clusters are Paused” for using DR TABLE on a running database.

Examples

The following example identifies the tables Employee and Department as participants in database replication.

DR TABLE Employee;
DR TABLE Department;