Oracle GoldenGate 12c and Oracle database version 11.2.0.4 and higher support the Streams2OGG
utility that converts Streams capture, propagate, and apply processes to GoldenGate equivalents. The utility is available for download on the Oracle Support Portal (https://support.oracle.com). You will need an MOS account to sign in.
At the time of writing, the downloaded zip file: streams2oggv3_0.zip
includes the following contents:
s2gg_config_check.sql
: This is a health check script to assess the Streams environment prior to migrationstreams2ogg.sql
: This is a PL/SQL package that must be compiled in the Streams admin user schema on both source and target databases
The installation script prompts for the GoldenGate admin user and a separate staging directory, as shown in the following code:
SQL> connect strmadmin/strmadmin@strmdb --Load the package in database SQL> @streams2ogg.sql Enter value for gg_username: ggadmin Enter value for staging_dir: /u01...