Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: replication 7<->8: Force - Fast

Re: replication 7<->8: Force - Fast

From: <zyman_at_my-deja.com>
Date: 2000/09/21
Message-ID: <8qd84a$tec$1@nnrp1.deja.com>#1/1

Ok,
I did it. Replication (fast) is working now.

In article <8ogl39$epj$1_at_nnrp1.deja.com>,   zyman_at_my-deja.com wrote:
>
>
> Yes I ctreated snapshot log on master then I created a snapshot.
> Also I use the simplest possible select : select * from
> table_name_at_db_link
>
> Maybe I should always create a public db links and then privet? ( it
> looks like ..... )
> I switch to advenced replication : it "loooks like" fast is working.
> But I cann't insert any row in master table (it has PK on fisrt
> column):
> insert into t2 values(10, 'aaa')
> ERROR at line 1:
> ORA-23326: the system is being quiesced
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 76
> ORA-06512: at "SYS.DBMS_REPUTIL", line 415
> ORA-06512: at "REPADMIN.T2$TP", line 18
> ORA-06512: at "REPADMIN.T2$RT", line 12
> ORA-04088: error during execution of trigger 'REPADMIN.T2$RT'
>
> In article <20000829.5453356_at_slu40736.hae.hydro.com>,
> <no.email_at_no.spam> wrote:
> > Did you create a snapshot LOG on the remote site ? Without snapshot
 log,=
> > =20
> > you can't use a fast refresh. The query is also subject to some=20
> > limitations (no union, intersect, ...).
> >
> > Marc
> > >>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<
> >
> > Op 2000-08-28, 18:15:48, schreef zyman_at_my-deja.com over het thema=20
> > replication 7<->8: Force - Fast:
> >
> > > Hello,
> > > I have very-very-very :) simple question for people who know :
 

> > > why I can't do fast refresh ( in basic replication) btw 7.3.4.1 and
 80=
 5?
> > > -- But in the same way complete is working
 

> > > And enother question :
> > > how to do fast refresh?
> > > -- I know that I need to set FAST in snapshot - but than my job
 failes=  

> > > :(
 

> > > thank U
> > > Andy
 

> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US