Oracle Database Syncronization

[gloggle]

I've got 6 Oracle 8.0.5 databases scattered throughout North America. Each database resides at one of our manufacturing facilities and contains inventory information regarding spare plant parts such as valves, reformer tubes, etc. Management at the corporate site wants to be able to see all parts from all plants at any given point in time so we don't have too many spare plant parts laying around. There is a separate user ID and password for each database. The key field on all of the tables is 'Plant'. How can I provide this central view of all of these databases? Can Microsoft Access help me with this? Can I somehow import the data nightly via batch? We use UC4 as our scheduling software.

 

[THoey]

I am sure you could figure a way to do this in Oracle, but since you asked, you could create an MS Access database, link all the tables, and then create reports, etc. "Alcohol is our friend, and it's about time we had more friends over."

Terry M. Hoey

 

[harris79]

I would create database links to each plant from the corporate site.

create database link plant1 connect to user1 identified by password1 using plant1;

Then a select statement like-
select field from table@plant1;

Will get the data, a simple stored proceedure will be able to
get the data from all the plants.

Hope this helps

Steve