1 Reply Latest reply: May 8, 2011 5:25 AM by Zlatko Sirotic RSS

    How to inherit referential integrity?

    akrbot
      Hi,

      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?
      Regards,