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

I check for the Oracle Magazine, they even have a script to export the database even if the compressed database exceeds the max file size. Check for the following site:

http://www.oramag.com/code/tip01168.htm

Winnie Liu

Thomas Kyte wrote in message <35a687a7.7396846_at_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 - 23:37:13 CDT