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

I spoke with Oracle support about this not too long ago. They said that it should be coming up with 64 bit versions, however, I have yet to try this on our HP-UX 11 system, which is 64 bit Oracle/OS.

Best Regards,

Nigel

In article <N55C2.2535$uJ1.1217_at_nnrp3.clara.net>,   "Dave Wotton" <Dave.Wotton_at_dwotton.nospam.clara.co.uk> wrote:
>
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 09:08:40 CST