Need your idea on setting up Distributed database

Dear all,

I have to plan a strategy for setting up the database. Let me explain = the scenario of operation.

Local databases are available in 245 locations and there will be one = centralized database.
Whenever there is a transaction occuring at each location it should be = posted to both the local database and the centralized database. We are = using oracle8i database.

How i can post the database transaction to local database after commit = as well as centralized database ?
This should happen in online.

How many dblinks a centralized oracle8i database server can support ? In = this case from each location=20
i need to have a database link to the centralized database server.

What database feature i can use to update the data in both local and = centralized database ?

I request every one to share every ones thoughts and tips and steps with = me.

Awaiting the response.

Regards,
Balasubramanian .M Received on Fri May 26 2000 - 12:17:07 CDT