Re: Looking for a scalable solution for many DB links

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Tue, 09 Dec 2003 21:41:28 +0100
Message-ID: <pncctv81nvs16v3dqficl89vaos4ojaj2o@4ax.com>

On Tue, 09 Dec 2003 20:22:50 +0000, Paul Moore <pf_moore_at_yahoo.co.uk> wrote:

>At the moment, I'm expecting to go with (1), but I'd love to convince
>myself that (2) would work.

I would like to add two other options

3) ask yourself and your management whether they have gone nuts by having 100+ databases at all and one central instance collecting all those tables. You are bound for disaster, whichever option you implement. Likely all those 100+ databases have only one schema, and you are treating Oracle as sqlserver.

4) Consider using Oracle replication.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Dec 09 2003 - 14:41:28 CST