5.1.7. Changing the Configured Replication Objects

During installation, you specify the tables and/or schemas that you want to replicate using the tpm option --oracle-redo-replicate-tables as follows:

--oracle-redo-replicate-tables=HR,LAB.TAB1

The above will replicate all tables in HR, but only the TAB1 table in the LAB schema.

Once you have installed the replicator, to change the list of configured tables, you need to issue the relevant commands below from within the orarr console. To load the console, issue the following:

shell> orarrd_servicename console

Then at the prompt, issue the relevant command from below:

  • View currently configured objects for replication

    orarr> list prepare all
  • Add a Schema

    orarr> prepare schema SCHEMANAME
  • Remove a Schema

    orarr> unprepare schema SCHEMANAME
  • Add a Table

    orarr> prepare table SCHEMANAME.TABLENAME
  • Remove a Table

    orarr> unprepare table SCHEMANAME.TABLENAME

    This method can also be used to exclude materialized views from replication. See Section 5.1.1.3, “Handling Materialized Views” for more information