Re: Oracle 9.2 Basic Replication
- From: amonte <ax.mount@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 May 2006 17:11:58 +0200
Hi again
I am back with further question about read only replication.
It turns out that 5 of tables I have to replicate have user defined
type/objects. I am not able to replicate these tables, getting this error
all the time:
ORA-21700: object does not exist or is marked for delete
It seems that this is not supported or what? Although in 9i New Features it
does say user defined types are supported.
Any comments?
TIA
Alex
On 5/12/06, amonte <ax.mount@xxxxxxxxx> wrote:
Ah right that is the nice old way I was talking about.
Time to find out how to define the refresh groups now :-)
Alex
On 5/12/06, Ghassan Salem <salem.ghassan@xxxxxxxxx> wrote:
>
> Alex,
> just create snapshot logs on the master site, and MVs on the 'slave
> sites'. You can use refresh groups to insure consistency. replication admin,
> proxy admin, ... are used when you have updatable snapshots (or
> master-master replication).
>
> rgds
>
>
> On 5/12/06, amonte < ax.mount@xxxxxxxxx> wrote:
> >
> > Hi all
> >
> > I am trying to replicate 50 tables from one database to another using
> > Oracle 9.2.0.7 on Sun Solaris. this will be basic replication, read
> > only MVs.
> >
> > I am reading the replication manual (which talks about ADVANCED
> > Replication) and it says I need to set up a master site and a materialized
> > view site, then in master site create a replication administrator, proxy
> > administrator etc (more steps).
> >
> > My previous experience in basic replication goes back to Oracle 8, at
> > that time I only hahd to create snapshots at snapshot site and create
> > snapshot logs at master site and create a refresh group to ensure data
> > integrity.
> >
> > In 9.2 do I really need to perform all the tasks I mentioned or I can
> > use the old Oracle 8 way?
> >
> > TIA
> >
> > Alex
> >
>
>
Other related posts:
