Re: Export and files > 2Gigs

Carlos A. Gonzalez wrote:
>
> Gentlemen:
>
> Here is what's happening.
>
> I am in the process of movin a large database (20 Gigs) from one host to
> another.
>
> The export file I'll be creating is over two Gigs space.
>
> The Oracle Gurus at my site tell me about a unix file size limitation that
> can not be greater than 2 Gigs.
>
> I am running oracle ver 7.2.3 under unix Solaris ver 5.2 in Sun Sparc
> hardware

Can you export to tape?:

     exp / full=y buffer=409600 volsize=5000M file=/dev/rmt/0

Can you export to a pipe and compress the output?:

     export: mknod /tmp/pipe p
             nohup compress < /tmp/pipe > /tmp/full_exp.dmp.Z &
             nohup exp / full=y file=/tmp/pipe &

     import: mknod /tmp/pipe p
             nohup uncompress < /tmp/full_exp.dmp.Z > /tmp/pipe &
             nohup imp / full=y file=/tmp/pipe &

You could also run the export on machine A while at the same time be importing on machine B. Do this by exporting to a pipe on machine A, and on machine B mount the machine A filesystem (NFS) and import from the machine A pipe.

Maybe even somthing like:

     export > pipe > compress > /dev/rmt/0
     import < pipe < uncompress < /dev/rmt/0

mailto:brian.maclean_at_teldta.com Received on Tue Jul 08 1997 - 00:00:00 CDT