Re: Export of database blows Sun's 32bit file size limits

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 08 Jul 1998 14:53:52 GMT
Message-ID: <35a687a7.7396846@192.86.155.100>

A copy of this was sent to Markz_at_starnet.lenfest.com (if that email address didn't require changing) On Wed, 08 Jul 1998 14:04:22 GMT, you wrote:

>We are trying to export a database that exceeds the size of Sun's max
>file size. Any suggestions ?
>MarK Z, 6b, rhymingly

I use a pipe out to compress to do it:

mknod exp.tmp.dmp p
gzip < exp.tmp.dmp > $FN &
exp userid=$UID buffer=20000000 file=exp.tmp.dmp full=y >>& expbkup.log

This results in a gzipped export file being created. As long as the gzipped file is less then 2gig (exports usually compress pretty good), it'll work.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jul 08 1998 - 09:53:52 CDT