Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: export file over 2 gig limit

Re: export file over 2 gig limit

From: thor hw <thor_at_echidna.net>
Date: Wed, 8 Apr 1998 14:54:34 -0700
Message-ID: <1998Apr8.145659.10106@vmsmail.gov.bc.ca>


Try this:

    make a pipe, export to it, compress/gzip the pipe output.

Export

  1. mknod exp_pipe p
  2. (cat exp_pipe |compress > myexportfile.dmp.Z &);exp prompt asking for export filename => exp_pipe

Import

  1. (zcat myexportfile.dmp.Z > exp_pipe &);imp prompt asking for export filename => exp_pipe

If you need to go much bigger you can go to tape ... but it is slower. Thor HW

Shaochun Lin wrote in message <6ggk2v$c512_at_beaker.nit.gwu.edu>...
>Is there any way to compress the export file while exporting,I got hit 2Gig
limit of AIX4.1 file size. Thanks,
>
Received on Wed Apr 08 1998 - 16:54:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US