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

From: MotoX <rat_at_tat.a-tat.com>
Date: Tue, 25 Aug 1998 12:04:18 +0100
Message-ID: <904042968.15005.0.nnrp-01.c2de712e@news.demon.co.uk>

One other thought - not mentioned in the replies you got - is to partition the table, then export by partition (obviously running multiple exports, not one export which picks up all the partitions). Some of our larger tables are growing up to 180,000,000 rows, and partitioning is a necessity.

MotoX.

dmoharir_at_hotmail.com wrote in message <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 Tue Aug 25 1998 - 06:04:18 CDT