Editorial question96.8K views3,975 votes0 answers1,655 following
AI-generatedConfiguring 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