If this is Unix, you can pipe the result to the "split" command to chop it
up into regular (perhaps 1GB) pieces. Of course to import will require you
to "cat" the pieces together before sending the file to the uncompress
pipe. Ugh!
dmoharir_at_hotmail.com wrote in article <6rrp9e$m15$1_at_nnrp1.dejanews.com>...
> 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 - 20:10:40 CDT
