This content has been marked as final. Show 2 replies
Yes, it would be possible to temporarily execute dbms_wm.enableversioning on the parent table. At least in most cases. If the table that you want to add as the child, is itself a parent to a 3rd table, and the new constraint is defined as 'on delete cascade', then we would not allow the grand-parent table to be disable versioned, without diasable versioning the other tables in the RIC set. Other than that case however, everything you are suggesting should work as expected.