Oracle shadow tables for tables without primary keys
Replicate Oracle tables without primary keys through shadow tables that database triggers keep in sync with inserts, updates, and deletes.
Added support for replicating Oracle tables that do not have primary keys.
For such tables, Artie creates a corresponding shadow table that mirrors the structure of the original table. Database triggers are configured to propagate insert, update, and delete operations from the source table to the shadow table.
The shadow table enables deterministic change tracking, allowing Artie to replicate data from Oracle tables that would otherwise be unsupported due to the absence of a primary key.
This expands compatibility with legacy Oracle deployments and improves replication coverage.
Configuration: Enabled automatically for Oracle source tables without primary keys.