troubleshooting Question

Matching data from tables in different Oracle databases

Avatar of carlino70
carlino70Flag for Argentina asked on
Oracle Database
11 Comments1 Solution558 ViewsLast Modified:
Hi Experts,
In a database 11g Standard Edition (no replication)
I need to create a stored procedure to perform the matching of data from tables with the same name but in different instances.
Both bases are updated with the same data by the application, but before courts in communication, drops the database, or server crash, data is NOT sent to the other end when service is restored.

Manually, and with just a table, I can do:
insert into tbl1
select * from tbl1 @ base2
between: 1 and: 2 - DATE fields, with the period to match
minus
select * from tbl1
between: 1 and: 2; - DATE fields, with the period to match
And then the other way around:
insert into tbl1
select * from tbl1 @ base1
between: 1 and: 2 - DATE fields, with the period to match
minus
select * from tbl1
between: 1 and: 2; - DATE fields, with the period to match
The issue is that I have 100 tables, and the process should sweep 100.
Only I do INSERT / UPDATE, depending on whether the records are empty, since the application may have created it, but no data.
You will have an example to follow, or some solution that can do what I need?
Thank you very much.
Regards
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros