Re: Export 2GB file size limitation

use a Unix split comand

cat expfile | split -b 1000m - exp &
exp system/manager file=expfile ..... (whatever)

This will put the first million bytes into a file called 'expaa' and the next million into 'expab' and so on until the end is reached.

To import this use
mknod inpipe p
cat exp* > inppipe&
imp sys/manager file=inpipe ...
rm inpipe

Works well.

N.K. Lim wrote:

> I was trying to export an Oracle 7.3.2.3 tablespace on AIX 4.2, but the
> export will fail when the dump file hits 2 GB, even though the OS
> supported >2GB file size. Is there any way to overcome this problem
> without using tape export?
>
> thks and rgds
> -------------------------------------------------------------------
> N.K. Lim limnk_at_yimei.pc.my Penang, Malaysia.
> -------------------------------------------------------------------
Received on Wed Apr 08 1998 - 17:34:30 CDT