Rollback process in advanced replication?

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Fri, 15 Dec 2000 17:40:14 +0530
Message-Id: <10711.124678@fatcity.com>

--------------121987B8BFBFA862CB12356A
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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
> Tél.: 01-46-39-14-49
> Fax : 01-46-39-59-88

--------------121987B8BFBFA862CB12356A

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

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:
<blockquote TYPE=CITE> 
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
 Tél.: 01-46-39-14-49
 Fax : 01-46-39-59-88</blockquote>
Received on Fri Dec 15 2000 - 06:10:14 CST