Where can I get information about how to correctly create and delete triggers on versioned tables?
Product: Oracle Database
Version: 19c
When I try to remove a trigger from a workspace manager versioned table, the according trigger in WMSYS schema gets invalid.
I tried to disable the trigger first, but it seems that it's not possible to drop a disabled trigger. It still shows up in "ALL_WM_TAB_TRIGGERS" after the drop command and can be enabled after the drop.