Re: Export utility and file size limits

How about compressing dump file on the fly during export ?!

        Check this out, it might help in beating 2GB barrier.

• create a named pipe $ mknod exp.pipe p
• read the pipe - output to compress in the background $ compress < exp.pipe > scott.exp.Z &
• you could use any compression utility.
• feed the pipe $ exp userid=scott/tiger file=exp.pipe ...

-R.K.Muthu
 rkmuthu_at_usa.net
 Oracle Certified Professional

In article <7bdp6i$ti$1_at_korweta.task.gda.pl>,   "Piotr Kolodziej" <pkol_at_otago.gda.pl> wrote:
> Kevin Seneviratne wrote in message <36D7CE32.43BA6C75_at_connect.com.au>...
> >Oracle 7.3.4.0.1
> >Solaris 2..6
> >When doing a conventional path export I get the error
> >EXP-00002: error in writing to export file
> >the moment the dmp file reaches 2GB.
> >Any ideas on how do I over come this 2GB limit ?
>
> See OS manuals whether any of supported filesystems
> allows to store files > 2GB (unfortunetally I don't know Solaris 2.6
> details). If there exists such filesystem type, you probably need to
> remake _proper_ filesystem on your device (heh, backup existing files
> & so on). Just another issue -- maybe you need patching OS to really
> support large files.
> However, consider compressing export as suggested in one of replies
> to your post.
>
> --
> Piotr Kolodziej pkol_at_otago.gda.pl
> Just my private opinion.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 03 1999 - 14:57:02 CST