RE: Need your idea on setting up Distributed database

Hi Bala,

We have a similar set up. We are using Tuxedo to achieve this. Tuxedo guarantees the committing a transaction across all nodes.

If u try to use dblinks and these nodes are spread over across many stations, then the performance will be slow.

Maheshwara Rao, L., Teki
E Mail : teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Balasubramanian M
Sent: Friday, May 26, 2000 8:56 AM
To: Multiple recipients of list ORACLE-L Subject: 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
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
Bangalore.

--
Author: Balasubramanian M
  INET: sbala_at_hclinsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).