Determines if the Replication Agent automatically marks tables for replication during initialization or DDL replication (for Oracle only).
false
true – User tables are automatically marked during initialization or DDL replication.
false – User tables are not automatically marked during initialization or DDL replication. They must always be marked using the pdb_setreptable command (default).
The default value for pdb_automark_tables is set to false when a Replication Agent instance is created. In this default setting, tables are never automatically marked for replication. To start or implement automatic marking of tables, changed the configuration parameter to true. When set to true, all user tables (those whose owners are not contained in the owner_filter_list) are marked for replication when the pdb_xlog command is executed with the init keyword. In addition, when replication of DDL commands is enabled (pdb_setrepddl setting is disabled by default), any create table command for a user table (those whose owners are not contained in the owner_filter_list) are automatically marked for replication.
Automatic marking of new tables (those created in the primary database with the create table command) occurs only when replication of DDL commands is enabled (pdb_setrepddl is set to enable), and the table is a user table (those whose owners are not contained in the owner_filter_list), and pdb_automark_tables is set to true.
Tables are automatically unmarked for replication when a drop table command is issued at the primary database and the operation is recorded in the redo log, regardless of the settings of pdb_setrepddl or pdb_automark_tables. This is because a dropped table cannot be replicated from.
Automatic marking of user tables operates independently from manual marking of tables using the pdb_setreptable command. In other words, you can always mark or unmark individual tables or all tables for replication using the pdb_setreptable command, regardless of the setting of pdb_automark_tables.
If the value is set to false, user tables are never automatically marked; they must be explicitly marked using the pdb_setreptable command.
