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.
thanks alot, it worked perfectly :)