Jared,
I'm replying to the list since I don't see Nihar's
email address.
Multi-master replication would be an ideal candidate
for this situation as long as there is a primary key
on the table or one or more columns which can be used
to simulate a PK. It's always important to implement
conflict resolution, but especially in this situation
where the same username could potentially be added at
both sites.
One could also use triggers to do distributed DML to
replicate the changes, but due to the two phase commit
process this can be a significant bottleneck which
doesn't scale.
/* SOAPBOX ON */
Replication is a complex feature which requires a
thorough understanding of the replication architecture
to implement it *successfully*. There are numerous
issues to consider before implementing replication. I
address some of these in my Replication Do's and
Don'ts paper to help people decide to use replication
only if it's the right tool for the job.
Bottom line... if you implement replication without
knowing what you're doing it's only a matter of time
before your luck will run out and you'll have
problems. Keeping your resume up to date would be a
good idea ;)
/* SOAPBOX OFF */
HTH,
-- Anita
--- Jared Still <[EMAIL PROTECTED]> wrote:
>
>
> FYI I am forwarding this to the list, so please
> address
> replies to the original sender.
>
> ---------- Forwarded Message ----------
> Date: Fri, 11 May 2001 12:45:43 +0530
>
> Hi jared
>
> This is Nihar from india. I am having some query
> regarding Oracle
> Replication.
> Basically i am having 2 diffrent server running
> oracle 8i on solaris.One is
> in usa and one is in india.Now the table i want to
> replicate is users
> database. I want to have unique username on both the
> end. but Us users
> database should be there on usa server and same for
> the indian database
> users.
> can u just help me in deciding replication method
> and can u pls tell me how
> should i go bout it..?
>
> though i am not an oracle developer pls explain me
> in details if u have
> time.
>
>
> thanks and regards
>
> - NIHAR SANGHVI
>
> NetMagic Solutions Pvt. Ltd.
> 22,Nirlon Complex,Western Express Highway,
> Goregaon (E), Mumabai 400 063
>
> Phone: 8723003 extn: 144
> www.netmagicsolutions.com
>
>
-------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
