Subscription with Bulk Materialization

You can use dump and load or manual coordination methods to synchronize databases.

To create a database subscription using dump and load coordination, use define subscription with the use dump marker clause. Both the primary and replicate databases and Replication Servers, must have the same server user ID, password, and role settings.

define subscription sub_2
  for database replication definition repdef_1
    with primary at PDS.primary_db
  with replicate at RDS.rdb
  subscribe to truncate table
  use dump marker