ALTER JSON RELATIONAL DUALITY VIEW

Use ALTER JSON RELATIONAL DUALITY VIEW to alter various options for a duality view like logical replication.

Prerequisites

You must have one of the following privileges to use this statement:

• The view must be in your own schema

• You must have the ALTER ANY TABLE system privilege

• You must have the OGG_CAPTURE role

Syntax

Description of the illustration alter_json_relational_duality_view.gif

duality_view_replication_clause

Description of the illustration duality_view_replication_clause.gif

Semantics

duality_view_replication_clause

Steps to Enable Duality View Replication

• You can enable logical replication for the duality view using ALTER JSON RELATIONAL DUALITY VIEW ENABLE LOGICAL REPLICATION.

  You can also enable logical replication with the command CREATE JSON RELATIONAL DUALITY VIEW

• Minimal (or subset database replication) supplemental logging must be enabled at the database or container level using ALTER PLUGGABLE DATABASE ADD SUPPLEMENTAL LOG DATA DDL.

• Database compatibleparameter must be 23.4 or higher

• Database parameter at the CDB level enable_goldengate_replication must be TRUE

To disable logical replication on a duality view use ALTER JSON RELATIONAL DUALITY VIEW DISABLE LOGICAL REPLICATION

Note: On a multi instance RAC database, you must run the ALTER SYSTEM ENABLE RAC TWO_STAGE ROLLING UPDATES ALL DDL, before you can enable or disable logical replication.

After you run ALTER SYSTEM ENABLE RAC TWO_STAGE ROLLING UPDATES ALL you cannot perform an online downgrade (unpatch) of your RAC database to DBRU23.5 or lower. You must take a downtime.

On a single instance database, you do not need to run ALTER SYSTEM ENABLE RAC TWO_STAGE ROLLING UPDATES ALL.