Determines if the Sybase 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 an Sybase 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.
Tables are automatically unmarked for replication when a drop table command issued at the primary and is recorded in the redo log, regardless of the settings of pdb_setrepddl or pdb_automark_tables. This is due to the fact a dropped table cannot be replicated from.
Automatic marking of user tables is independent of manual marking of tables using the pdb_setreptable command. Meaning, 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.