Re: Export >2GB files w/7.3.4.3.0 & Solaris 2.6

Bob Wickline wrote in message <36d8b4ae.3166470_at_news.cyberramp.net>... [snip]
>Yea yea I know all about compressing the file thru the named-pipe.
>However, it's only a matter of time until the compressed file is >2GB
>in size. Then what? I supposed then that Oracle is through with it
>and the compress command has the file handle so it will be allowed to
>be >2GB in size. Seems like a poor work-around when it would be
>pretty easy for Oracle to add 64-bit filesystem support for >Solaris
>2.6 platforms. Don't they already publish a 32-bit AND 64-bit MIPS
>release??

You'll need to ask Oracle when they're genuinely going to support 2Gb+ files. In the meantime, the limit of 2Gb for the data compressed through a pipe can easily be overcome. Replace your pipe:

      compress -c < my_pipe > my_compressed_file.Z &

by

      compress -c < my_pipe | split my_split_file 1000k &

[ check the syntax: man split ]. This will will create multiple files of 1000k named my_split_file.{aa,ab,ac...}. You can have 26*26 of them so should work for a few years yet! To import:

      cat my_split_file.* | compress -dc > my_pipe &

Dave.
--
Remove "nospam" from my address to reply by email Received on Sun Feb 28 1999 - 00:10:53 CST