RE: Export Import problem with compress

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Fri, 8 Dec 2000 15:19:41 -0500
Message-Id: <10704.124107@fatcity.com>

Try=20
uncompress < exp.dmp.Z>mypipe &
sleep 2
imp
=20
Henry

-----Original Message-----
From: DEMANCHE Luc (Cetelem) [mailto:luc.demanche_at_cetelem.fr] Sent: Friday, December 08, 2000 5:21 AM
To: 'oracledba_at_lazydba.com'
Cc: 'oracle-l_at_fatcity.com'
Subject: Export Import problem with compress

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

mknod mypipe p
compress < mypipe > expfirisq.dmp.Z &
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
zcat expfirisq.dmp.Z > mypipe &
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
IMP-00000 Import terminated unsuccessfully=20 We use Oracle 8.1.6.2 and Sun Solaris 2.6 32-bits with 64-bit files.=20 Any ideas?=20

-----------------=20

Luc Demanche=20
CETELEM=20
T=E9l.: 01-46-39-14-49=20 Received on Fri Dec 08 2000 - 14:19:41 CST