This parameter is available only for Oracle and Microsoft
SQL Server.
Determines if the Replication Agent automatically marks tables for replication during DDL replication.
false
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 false when an Replication Agent instance is created. In this default setting, tables are never automatically marked for replication. If automatic marking of tables is desired, this configuration parameter value should be changed to true. When set to true, all user tables (those whose owners are not contained in the owner_filter_list) will be 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) will automatically be marked for replication.
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.
