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: Tue, 29 Aug 2000 15:32:56 GMT
Message-ID: <8ogl39$epj$1@nnrp1.deja.com>

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. Received on Tue Aug 29 2000 - 10:32:56 CDT

Original text of this message

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