Re: replication with Indexes
- From: "Arun Annamalai" <oracle@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Jul 2004 09:05:11 -0500
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...
1. clustering
2. log based replication
3. trigger based replication(oracle internal) - Advanced replication
4. transaction based replication.
5. 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@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, May 28, 2004 4:50 PM
Subject: RE: replication with Indexes
> can u pl send example if possible.
> thx
>
>
> >From: Stephen.Lee@xxxxxxxx
> >Reply-To: oracle-l@xxxxxxxxxxxxx
> >To: oracle-l@xxxxxxxxxxxxx
> >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@xxxxxxxxxxxxx
> >put 'unsubscribe' in the subject line.
> >--
> >Archives are at //www.freelists.org/archives/oracle-l/
> >FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
