Enable-adg_redirect_dml Parameter in 19c
SQL> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
primary
SQL> show parameters adg_redirect_dml
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
adg_redirect_dml boolean TRUE
standby
SQL> show parameters adg_redirect_dml
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
adg_redirect_dml boolean TRUE
created table primary and inserted one row and i can see table and data in standby
when I am trying to delete row from standby
SQL> delete from testDML;
delete from testDML
*
ERROR at line 1:
ORA-02055: distributed update operation failed; rollback required
ORA-40509: cursor compilation failed because abstract data type was created at