3 Replies Latest reply: Jul 19, 2011 7:25 PM by 874803 RSS

    Foreign key relationship lost after version-enabling tables

      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:

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

      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 -