3 Replies Latest reply on Jul 20, 2011 12:25 AM by 874803

    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 -