Re: Rollback process in advanced replication?

Hi Suganya,

You CANN'T rollback the data once it is replicated to the other site. In other words ONLY committed records go to the second site.

Regards,
Mohan

Suganya wrote:
>
> Hi all
> We are in the testing process of Multi Master Replication. All the
> neccessary links for Multi Master Replication is over .
>
> We then Inserted data in the Master Definition Site and our
> Scheuled
> interval to update the data in other Master sites is one minute. If we
>
> give commit, the data is propogated in other Master Sites after the
> Scheduled Interval. But without commit it is not working. If that is
> case how do we go in for ROLLBACK.
> Thanks and Regards
> Suganya
>
> "DEMANCHE Luc (Cetelem)" wrote:
>
> >
> >
> > Hi gurus,
> > I'm performing some tests with export and compress functions. Here
> > is my script to export:
> >
> > mknod mypipe p
> > compress < mypipe > expfirisq.dmp.Z &
> > exp file=mypipe log=expfirisq.log parfile=expfirisq.par
> >
> > The volume of my dump file is 3G B.
> > The problem occurs when I want to import. Here is my script:
> >
> > mknod mypipe p
> > zcat expfirisq.dmp.Z > mypipe &
> > imp file=mypipe log=impfirisq.log userid=aaa/bbb fromuser=firisq
> > touser=aaa tables=bac
> >
> > I get the following error message:
> > expfirisq.dmp.Z : Value too large for defined data type
> > IMP-00009 abnormal end of export file
> > IMP-00000 Import terminated unsuccessfully
> > We use Oracle 8.1.6.2 and Sun Solaris 2.6 32-bits with 64-bit files.
> >
> > Any ideas?
> >
> > -----------------
> > Luc Demanche
> > CETELEM
Received on Fri Dec 15 2000 - 07:58:34 CST