Why Do Tables Without Supplemental Logging Appear in the Schema List?

Question

In the Schema tab in Fivetran, I see tables that are not enabled for supplemental logging. Why are these tables still available?

Environment

Connector: High Volume Agent Oracle

Answer

Tables without primary keys can appear in the schema list even when supplemental logging is not enabled. For these tables, we use the Oracle ROWID as the replication key to identify and replicate rows.

Tables with primary keys may still require supplemental logging, depending on your replication configuration and use case.