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_at_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.
Received on Fri Dec 08 2000 - 05:23:00 CST