Re: Exporting huge tables from Oracle 8.0.5 - works exp and imp absolutly no size limitations but disk space

From: Darryl Batten <dbatten_at_pacbell.net>
Date: Fri, 01 Dec 2000 17:19:36 -0800
Message-ID: <3A284E28.6CA1DFD8_at_pacbell.net>


here is a method to export and import without size limits

it utilizes:

    unix named pipes
    the split command which cuts a file stream into equal lengths     and any compression you desire

works like this

Make the named pipe

    mknod orapipe p

Do your oracle export using the pipe as the output file ( important to use a logfile
as the export stdin and stdout will be diverted to /dev/null and the command run as
a background job

    exp blah blah blah ... file = orapipe > /dev/null 2>&1 &

    you can log the export from another window using tail -f p on the logfile

Direct the output stream of the pipe thru your favorite compression and from there to the split command

    cat orapipe | compress | split -b 2000m - exportfile

the reults of this will be x number of files ( however many 2000 meg files you export needs) named exportfileaa .... exportfilezz each being 2000 megs in size.

For the import reverse the process

Push the exportfile thru uncompression and into the pipe

    cat exportfile* | uncompress > orapipe 2>/dev/null &

Have oracle use the pipe as the file again

    imp blah blah blah ... file = orapipe

Tomasz Olczak wrote:

> Dear Everybody,
>
> I was trying to export a huge table (around 3.5GB of total extents) to a
> file using Oracle export utility and I got this error message:
>
> EXP-00002: error in writing to export file
> EXP-00222: System error message 5
> EXP-00000: Export terminated unsuccessfully
>
> I repeated the try but it finished the same way. It is interesting that
> both times it happened at the moment the export file grew to 2147483647
> bytes. I have enough free space on the disk so I was thinking that maybe
> it is some OS limitation (I run on Solaris 2.6)?
> But on the other hand one Oracle datafile on the same machine has
> already exceeded 5.7GB.
> What could be the reason than?

--
-----------------------------------------------------
Click here for Free Video!!
http://www.gohip.com/free_video/
Received on Sat Dec 02 2000 - 02:19:36 CET

Original text of this message