Re: Exporting huge tables from Oracle 8.0.5

An easier way:

exp parfile=file.par file=stdout 2>exp.stderr | gzip 2>gzip.stderr
>dumpfile.gz &

The file= parameter needs "stdout" as it's argument and exp will simply write to
fd[1] ( stdout ).

I wish imp would do the same but using file=stdin does not work there.

-Kevin
"Cong Tang" <Cong.Tang_at_ctbto.org> wrote in message news:20001201.150719.776247_at_CTBTO.ORG...
> Hello,
>
> Oracle export file is limited to 2GB. This is true for Oracle 7.3, Oracle
> 8.0 and even Oracle8i 8.1.5. Oracle8i support multiple export files, each
> has the maximum limit of 2GB. For Oracle7.3 and Oracle 8.0 under Solaris
 2.6
> and above, you can overcome this limitation by using a name pipe. For
> example:
> # Creating a pipe
> /usr/sbin/mknod /export_dir/exp_pipe p
> # Exporting the whole database
> /usr/bin/compress < /export_dir/exp_pipe >
 /export_dir/export_file.dmp.Z
> &
> exp system/manager file=/export_dir/exp_pipe full=y
> # Output will be written to /export_dir/export_file.dmp.Z, which is
> unlimited under Solaris 2.6 and above.
> rm /export_dir/exp_pipe
> You can also use a name pipe for importing:
> /usr/sbin/mknod /export_dir/imp_pipe p
> /usr/bin/uncompress < /export_dir/export_file.dmp.Z >
 /export_dir/imp_pipe
> &
> imp system/manager file=/export_dir/imp_pipe full=y
> rm /export_dir/imp_pipe
>
> I hope this will help.
>
> Cong Tang
>
> 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?
>
Received on Fri Dec 01 2000 - 17:34:27 CET