Configuring Oracle GoldenGate DDL Replication Privileges for Zero‑Downtime Migration
Goal: Configure Oracle GoldenGate bidirectional replication so that DDL statements (CREATE, ALTER, DROP) are captured on the source and applied on the target throughout a zero‑downtime migration of a small OLTP application. Uncertainty: The GGSCI user must hold the EXECUTE privilege on DBMS_GOLDENGATE_AUTH and the ALTER ANY TABLE system privilege to replicat