Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: replication 7<->8: Force - Fast
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