Message-Id: <10711.124678@fatcity.com> From: Suganya Date: Fri, 15 Dec 2000 17:40:14 +0530 Subject: Rollback process in advanced replication? --------------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 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