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

What are your exp options? Are you grabbing the indexes and constraints? (Those can be turned off.)

I don't know of any way to grab segments of the table to export using exp. Maybe you could write something to do that yourself. I haven't tried this, but maybe there is a way that you can use the split command (assuming you are running this under unix) to split the file up into manageable chunks and then compress the chunks.

Maybe you could try looking this up under Oracle MetaLink.

Hope this helps.

HAP In article <6rrp9e$m15$1_at_nnrp1.dejanews.com>, 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 - 20:50:45 CDT