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

Home -> Community -> Mailing Lists -> Oracle-L -> Rollback process in advanced replication?

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
<br>We are in the testing process of Multi Master Replication. All the
<br>neccessary links for Multi Master Replication is over .
<p>&nbsp;&nbsp;&nbsp;&nbsp; We then Inserted data in the Master Definition
Site and our Scheuled
<br>interval to update the data in other Master sites is one minute. If
we
<br>give commit, the data is propogated in other Master Sites after the
<br>Scheduled Interval. But without commit it is not working. If that is
<br>case how do we go in for ROLLBACK.
<br>Thanks and Regards
<br>Suganya
<p>"DEMANCHE Luc (Cetelem)" wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Times New Roman"><font size=-1>Hi gurus,</font></font>
<br><font face="Times New Roman"><font size=-1>I'm performing some tests
with export and compress functions. Here is my script to export:</font></font>
<p><font face="Times New Roman"><font size=-1>mknod mypipe p</font></font>
<br><font face="Times New Roman"><font size=-1>compress &lt; mypipe > expfirisq.dmp.Z
&amp;</font></font>
<br><font face="Times New Roman"><font size=-1>exp file=mypipe log=expfirisq.log
parfile=expfirisq.par</font></font>
<p><font face="Times New Roman"><font size=-1>The volume of my dump file
is 3G B.</font></font>
<br><font face="Times New Roman"><font size=-1>The problem occurs when
I want to import. Here is my script:</font></font>
<p><font face="Times New Roman"><font size=-1>mknod mypipe p</font></font>
<br><font face="Times New Roman"><font size=-1>zcat expfirisq.dmp.Z > mypipe
&amp;</font></font>
<br><font face="Times New Roman"><font size=-1>imp file=mypipe log=impfirisq.log
userid=aaa/bbb fromuser=firisq touser=aaa tables=bac</font></font>
<p><font face="Times New Roman"><font size=-1>I get the following error
message:</font></font>
<br><font face="Times New Roman"><font size=-1>expfirisq.dmp.Z : Value
too large for</font></font> <font size=-1><font face="Arial">d</font><font face="Times New Roman">efined data type</font></font>
<br><font face="Times New Roman"><font size=-1>IMP-00009 abnormal end of
export file</font></font>
<br><font face="Times New Roman"><font size=-1>IMP-00000 Import terminated
unsuccessfully</font></font>
<br><font face="Times New Roman"><font size=-1>We use Oracle 8.1.6.2 and
Sun Solaris 2.6 32-bits with 64-bit files.</font></font>
<br><font face="Times New Roman"><font size=-1>Any ideas?</font></font>
<p><font face="Arial"><font size=-1>-----------------</font></font>
<br><font face="Arial"><font size=-1>Luc Demanche</font></font>
<br><b><i><font face="Arial">CETELEM</font></i></b>
<br><font face="Arial"><font size=-1>T&eacute;l.: 01-46-39-14-49</font></font>
<br><font face="Arial"><font size=-1>Fax : 01-46-39-59-88</font></font></blockquote>
Received on Fri Dec 15 2000 - 06:10:14 CST

Original text of this message

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