Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export Problem : Compressed file bigger than 2GB !

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

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 24 Aug 1998 21:37:07 -0500
Message-ID: <35E22352.6459CA99@deere.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US