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
Last activity: Sep 30, 2022, 02:21 PM