Supply a Data Definitions File on a NonStop Target

To replicate data between source and target NonStop SQL/MX databases, you must supply source data definitions to the Replicat process, even though the two databases might be identical in version and structure. There are slight differences in the way that metadata is returned to Oracle GoldenGate by the native API from the source database and by ODBC from the target database.

  1. Create a data definitions file with the DEFGEN utility.
  2. Transfer the definitions file to the target system.
  3. Specify the fully qualified name of the definitions file with the SOURCEDEFS parameter in the Replicat parameter file.

For more information about data-definitions files, see Understanding Data Definition Files.