(Oracle and Microsoft SQL Server only) Determines if Replication Agent automatically marks tables for replication during DDL replication.
true – user tables are automatically marked during DDL replication.
false – user tables are not automatically marked during DDL replication. They must always be marked using the pdb_setreptable command (default).
The default value for pdb_automark_tables is set to true when a Replication Agent instance is created. In this default setting, 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 enabled by default), any create table command for a user table (those whose owners are not contained in the owner_filter_list) is automatically marked for replication. If automatic marking of tables is not desired, this configuration parameter value should be changed to false.
Automatic marking of new tables (those created in the primary database with the create table command) will only occur 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. Modifying the owner_filter_list after the initialization may cause inconsistencies.
Tables are automatically unmarked for replication when a drop table command issued at the primary and is recorded in the transaction log, regardless of the settings of pdb_setrepddl or pdb_automark_tables. This is due to the fact that a dropped table cannot be replicated from.
Automatic marking of user tables is independent of manual marking of tables using the pdb_setreptable command. In other words, you can always mark or unmark individual or all tables for replication using the pdb_setreptable command, regardless of the setting of pdb_automark_tables.