Database Administration (MOSC)

MOSC Banner

Where can I get information about how to correctly create and delete triggers on versioned tables?

edited Jun 21, 2024 1:29PM in Database Administration (MOSC) 1 commentQuestion

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.

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