Re: Export Problem : Compressed file bigger than 2GB !

Check out the unix 'split' command. You can pipe the export into split -n1024m target

This will produce a set of files: targetaa, targetab ... targetzz. Each file (except the last) will be 1024 megabytes.

You can also pipe the output of compress into split.

The familiar unix 'cat' concatenates the files and can pipe through uncompress to imp.

dmoharir_at_hotmail.com wrote:

> We have one large table(75 million rows) which we export using pipes and
> compression.
> Now , the size of the compressed file itself is approaching 2 GB.
> Currently it is 1800 MB. Can any one suggest better ways of exporting
> this table ?
> Thanks in Advance
>
> Devendra
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 24 1998 - 21:37:07 CDT