Sample Header Ad - 728x90

Oracle Accessing Data from Two Databases Transparently

0 votes
0 answers
28 views
Our Oracle version is 19c We have a need to split our data into two separate databases. Most recent data will go into DB_1. Older data will go into DB_2. We do have Webserver tier. One options is to have views as follows CREATE VIEW all_cust as SELECT * FROM customer@DB_1 where ( date within 1 months ) union SELECT * from customer@DB_2 where ( date > 1 months ) But this will require massive changes to application - because all accesses to CUSTOMER will need to be changed to ALL_CUST. Can the above setup be configured so that it is completely transparent to application ? Can VPD be a solution to this ?
Asked by oradbanj (141 rep)
Sep 30, 2022, 02:11 PM
Last activity: Sep 30, 2022, 02:21 PM