Re: replication with Indexes

From: Arun Annamalai <oracle_at_shakaboom.com>
Date: Tue, 27 Jul 2004 09:05:11 -0500
Message-ID: <003901c473e2$bd723c40$3401a8c0@mpls1.epredix.com>

hmm..this is interesting.

Replicate an index? should you? why would you (i.e. reason)?

Replication concept is basically to replicate data given the same structure on both sides. Sometimes you might want to replicate DDLs that is the change that happens on one master to the another. But not to the level of replicating indexes and sequences? hmm.

I dont think you had looked into "CONFLICT RESOLUTION". Sequences and primary key values would be the main thing that would hold you from going to master to master replication. in short, Standby database is your best option ie. where you just want to failover.

If you are looking at load balancing(between two master to master) then it is another story....you need to look into lot of options that falls in HA(high availability) category...

clustering
log based replication
trigger based replication(oracle internal) - Advanced replication
transaction based replication.
Advanced queuing - queue transaction centrally and pass it to the masters. ...

There are various other option..that I can go on listing....let me know if you need more details.

Arun Annamalai

Original Message ----- From: "Seema Singh" <oracledbam_at_hotmail.com> To: <oracle-l_at_freelists.org> Sent: Friday, May 28, 2004 4:50 PM Subject: RE: replication with Indexes

> can u pl send example if possible.
> thx
>
>
> >From: Stephen.Lee_at_DTAG.Com
> >Reply-To: oracle-l_at_freelists.org
> >To: oracle-l_at_freelists.org
> >Subject: RE: replication with Indexes
> >Date: Fri, 28 May 2004 08:16:47 -0500
> >
> > > -----Original Message-----
> > > If we run the sql as you suggested will show error
> > > ORA-00955: name is already used by an existing object
> > > Pl advice
> >
> >It might be that "on prebuilt table" is not supported in 8.1.6. I don't
> >have an 8.1.6 database here to try.
> >
> >----------------------------------------------------------------
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >----------------------------------------------------------------
> >To unsubscribe send email to: oracle-l-request_at_freelists.org
> >put 'unsubscribe' in the subject line.
> >--
> >Archives are at http://www.freelists.org/archives/oracle-l/
> >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> >-----------------------------------------------------------------
>
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar – get it now!
> http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 27 2004 - 09:03:55 CDT