Balasubramanian,
This is an ideal situation for replication. Whether
you go with read-only snapshots, updateable snapshots
or multi-master replication depends on the number of
sites involved and the business needs. In general
multi-master replication becomes rather difficult to
maintain with more than 8-9 master sites. I'm not
saying it can't be done, but the amount of
maintenance, and related headaches, increases
dramatically once you get above that threshold.
Personally I prefer to limit multi-master to < 4
sites.
8i supports read-only and updateable snapshots with
the standard edition (8.0 and below require Enterprise
Edition for Updateable snapshots); multi-master
replication requires EE in all versions.
HTH,
- Anita
- Balasubramanian M <sbala_at_hclinsys.com> wrote:
> 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).
Do You Yahoo!?
Received on Mon May 29 2000 - 20:05:44 CDT
