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 and later
Information in this document applies to any platform.


 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




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.