9 Replication of JSON Data
You can use Oracle GoldenGate to replicate tables that have columns containing JSON data.
In particular, you can replicate textual JSON data (VARCHAR2
, CLOB
, or BLOB
) in the primary server to JSON
type data in the secondary. You can also replicate textual data to textual data or JSON
type data to JSON
type data.
Be aware that Oracle GoldenGate requires tables that are to be replicated to have a nonvirtual primary key column; the primary key column cannot be virtual.
All indexes on the JSON data will be replicated also. However, on the replica database, you must carry out any Oracle Text operations that you use to maintain a JSON search index. Here are examples of such procedures:
-
CTX_DDL.sync_index
-
CTX_DDL.optimize_index
See Also:
-
Oracle GoldenGate for information about Oracle GoldenGate
-
Oracle Text Reference for information about
CTX_DDL.sync_index
-
Oracle Text Reference for information about
CTX_DDL.optimize_index
Parent topic: Store and Manage JSON Data