1. Microservices Architecture Documentation
  2. Prepare
  3. Prepare Databases
  4. Oracle
  5. Oracle: Supported Data Types, Objects, and Operations for DDL and DML
  6. Details of Support for JSON-Relational Duality Views and JSON Collection Tables

Details of Support for JSON-Relational Duality Views and JSON Collection Tables

Oracle GoldenGate 23ai (23.6) supports various replication use cases for JSON Relational Duality Views and JSON Collection Tables. The following list focusses on these scenarios:

  • COMPATIBLE paramter for JSON-Relation Duality Views and JSON Collection Tables: The source and target Oracle Database must have the COMPATIBLE parameter set to 23.4.0.0.0 or higher in order enable support for JSON Relational Duality Views and JSON Collection Tables. This feature also requires Oracle GoldenGate 23.6 or higher

  • JSON-Relational Duality Views and/or JSON Collection Tables to Data Streams: Oracle GoldenGate can replicate changes made to JSON Duality View as JSON objects to GoldenGate Data Streams.

  • JSON Collection Tables to JSON Collection Tables: Oracle GoldenGate can replicate data between JSON Collection Tables.

  • Duality Views to Collection Tables: Oracle GoldenGate can replicate data from Duality Views to Collection Tables, essentially moving data between these two JSON-focused features.

  • Duality Views to Duality Views Replication between Underlying Tables: Oracle GoldenGate allows replicating the underlying tables from Duality Views to Duality Views, without replicating the view. If supplemental logging is enabled for a JSON Duality Views, it generates extra redo on top of the existing relational table.

    Note:

    Replication from one Duality View to another is not supported.