Oracle GoldenGate Users (Database)
A user is required in the source database for the Manager process if you are using Oracle GoldenGate DDL support. This user performs maintenance on the Oracle GoldenGate database objects that support DDL capture.
A user is required in either the source or target database for the
DEFGEN
utility. The location depends on where the data
definition file is being generated. This user performs local metadata queries to
build a data-definitions file that supplies the metadata to remote Oracle GoldenGate
instances.
Additional users or privileges may be required to use the following features, if Extract will run in classic capture mode:
-
RMAN log retention, see Log Retention Options.
-
TDE support, see Configuring Oracle TDE Data in Classic Capture Mode.