Re: Exporting huge tables from Oracle 8.0.5 - works exp and imp absolutly no size limitations but disk space
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