Disable Trigger on Active Standby Database
Hi,
we use dataguard and I want to know if it is somehow possible to disable an after servererror on database trigger on the active standby database?
I can check with an SQL if I am on the PRIMARY or PHYSICAL STANDBY db but this produces additional overhead e.g. always execute -> SELECT database_role FROM v$database;
The trigger can't insert the error in a table anyway because the standby db is in open mode -> READ ONLY WITH APPLY, so the trigger itself always fails. Is there a way to disable it?
thx