Export Import problem with compress

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Fri, 8 Dec 2000 11:21:14 +0100
Message-Id: <10704.123987@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C06100.9A2F40FA
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi gurus,=20
I'm performing some tests with export and compress functions. Here is = my
script to export:=20

mknod mypipe p=20
compress < mypipe > expfirisq.dmp.Z &=20 exp file=3Dmypipe log=3Dexpfirisq.log parfile=3Dexpfirisq.par=20

The volume of my dump file is 3G B.=20
The problem occurs when I want to import. Here is my script:=20

mknod mypipe p=20
zcat expfirisq.dmp.Z > mypipe &=20
imp file=3Dmypipe log=3Dimpfirisq.log userid=3Daaa/bbb = fromuser=3Dfirisq touser=3Daaa
tables=3Dbac=20

I get the following error message:=20
expfirisq.dmp.Z : Value too large for defined data type=20 IMP-00009 abnormal end of export file=20 IMP-00000 Import terminated unsuccessfully=20 We use Oracle 8.1.6.2 and Sun Solaris 2.6 32-bits with 64-bit files. Any ideas?

Luc Demanche
CETELEM
T=E9l.: 01-46-39-14-49
Fax : 01-46-39-59-88

------_=_NextPart_001_01C06100.9A2F40FA
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Export Import problem with compress</TITLE>
</HEAD>
<BODY>

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=3Dmypipe log=3Dexpfirisq.log parfile=3Dexpfirisq.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=3Dmypipe log=3Dimpfirisq.log userid=3Daaa/bbb = fromuser=3Dfirisq touser=3Daaa tables=3Dbac 


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=E9l.: 01-46-39-14-49
 Fax : 01-46-39-59-88
Received on Fri Dec 08 2000 - 04:21:14 CST