1 Reply Latest reply on May 8, 2011 10:25 AM by Zlatko Sirotic

    How to inherit referential integrity?


      I have 2 Applications in different shema with tables App1->Customer and App2->Customer. Entityes is quite simmilar, buth with different column names.
      In both App exist some tables with forign key tu Customer table. Is it possible to replace App2->Customer table wit somethong like
      (Materialized) view from App1->Customer ( with table name and column names in App2) and inherit referential integrity?
      Is there any other way or database feature to solve this problem?