My Oracle Support Banner

ORA-20108 When Trying to Version Enable A Table Which Has A Trigger Defined (Doc ID 254788.1)

Last updated on APRIL 24, 2020

Applies to:

Workspace Manager - Version 9.2.0.2 and later
Information in this document applies to any platform.

Symptoms

 Trying to version enable a table that has a row level trigger defined results in the following errors:

SQL> exec dbms_wm.enableversioning('PROJECT','VIEW_WO_OVERWRITE');
BEGIN dbms_wm.enableversioning('PROJECT','VIEW_WO_OVERWRITE'); END;

*
ERROR at line 1:
ORA-20108: triggering event 'INSERT OR UPDATE' not allowed
ORA-06512: at "SYS.LTDDL", line 517
ORA-06512: at "SYS.LTDDL", line 1273
ORA-06512: at "SYS.LTDDL", line 1259
ORA-06512: at "SYS.LT", line 8383
ORA-06512: at line 1

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.