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?
Create view App2.Customer using App1.Customer table, and route referential integrity (in schema App2) to App1.Customer table
create (fast refreshable) materialized view App2.Customer using App1.Customer.