This discussion is archived
3 Replies Latest reply: Jul 19, 2011 5:25 PM by 874803 RSS

Foreign key relationship lost after version-enabling tables

874803 Newbie
Currently Being Moderated
I created 2 tables for testing this: Address table and Customer table that has an AddressId column referencing the primary key Id column in Address table.

Then I ran the following statement in pl/sql developer:

begin
dbms_wm.enableversioning('address, customer', 'VIEW_WO_OVERWRITE');
end;

Then I couldn't find the foreign key in either customer_lt or customer_aux table. What's going wrong here?

Thanks for any clue.

- Nico -

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points