Mark tables for replication with any Replication Agent instance.
Before you can mark tables for replication, you must create the Replication Agent transaction log objects.
pdb_setreptable pdb_table
where pdb_table is the name of the primary database table that you want to mark for replication.
If pdb_setreptable returns information that the specified table is marked for replication, you do not need to continue this procedure.
If pdb_setreptable returns information that the specified table is not marked, continue this procedure to mark the table for replication.
pdb_setreptable pdb_table, mark
pdb_setreptable pdb_table, rep_table, mark
where rep_table is the name of the table in the replicate database.
pdb_setreptable pdb_table, mark
create replication definition my_table_repdef with primary at data_server.database with all tables named pdb_table ...
If the table in the replicate database has a different name from the primary table in the table replication definition, the table replication definition must map to the table in the replicate database. For example,
create replication definition my_table_repdef with primary at data_server.database with primary table named pdb_table with replicate table named rep_table ...
pdb_setreptable pdb_table, rdpri_table, mark
where rdpri_table is the name of the primary table in the table replication definition. The table replication definition must map to the table in the replicate database.
create replication definition my_table_repdef with primary at data_server.database with all tables named rdpri_table ...
If the table in the replicate database has a different name from the primary table in the table replication definition, the table replication definition must map to the table in the replicate database. For example,
create replication definition my_table_repdef with primary at data_server.database with primary table named rdpri_table with replicate table named rep_table ...
pdb_setreptable pdb_table, mark, owner
wherepdb_table is the name of the table that you want to mark for replication.
true (the default), the table you marked for replication is ready for replication immediately after pdb_setreptable returns successfully. You can skip the next step for using pdb_setreptable to enable replication for a marked table.
false, you must enable replication for the table, as described in the next step.
pdb_setreptable pdb_table, enable