Message-Id: <10704.123990@fatcity.com> From: "Daemen, Remco" Date: Fri, 8 Dec 2000 12:23:00 +0100 Subject: RE: Export Import problem with compress Hi Luc, Try cat mypipe | compress > expfirisq.dmp.Z & instead of > compress < mypipe > expfirisq.dmp.Z & with your export. HTH, Remco > ---------- > From: DEMANCHE Luc (Cetelem)[SMTP:luc.demanche@cetelem.fr] > Sent: vrijdag 8 december 2000 11:30 > To: Multiple recipients of list ORACLE-L > Subject: Export Import problem with compress > > 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.