You can use Oracle GoldenGate to replicate tables that have columns containing JSON 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, you must execute, on the replica database, 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