Re: 2 gig limit?

Hi:

Another way to fix it that I used on AIX, where I had the same problem, is to compress the export while generating the .dmp file.

/etc/mknod pipe.pip p # create a pipe
gzip <pipe.pip >expdat.dmp.gz & # launch gzip to compress your file exp userid.... file=pipe.pip

Okay. You'll create a export file already compressed. gzip is very effective on .dmp files, because it has a lot of redundancies.

Of course you can also export directly to tape, because exp will automatically split in many tapes. But I prefere to write to a disk and after that copy the file to 2 or more tapes. I don't trust on tapes :-)

Regards,

Carlos Netto
Software Design Informatica
Brazil

In article <7l0k89$csm$1_at_nnrp1.deja.com>,   argosy22_at_my-deja.com wrote:
> Hi all,
>
> We use:
> Oracle 7.3.4 on HP. Unix 10.20.
>
> We were having some problems yesterday with
> some export files. The people that we sent
> them to, could not successfully import them.
>
> I noticed that the file size was 2.55 billion bytes.
> 2 gigs is only 2.47 billion bytes.
>
> I seem to remember hearing about some 2 gig limits,
> which would explain why the import wouldn't work.
> Are these limits on the Unix side, or the HP side?
>
> Regards,
>
> Argosy

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 23:38:52 CDT