Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center