Re: export error (file too large > 2Gbyte)

From: <igor4874_at_my-deja.com>
Date: Fri, 20 Aug 1999 11:04:21 GMT
Message-ID: <7pjcnh$htl$1_at_nnrp1.deja.com>


In article <37BD10AA.C3C9F148_at_gtt.es>,   Jose Antonio =?iso-8859-1?Q?=D1iguez?= <josean_at_gtt.es> wrote:
> I have a RS/6000 with AIX 4.3.1 and Oracle
8.0.5.
> The Oracle's database is big (> 8 GB.)
> When I execute:
>
> exp / full=yes file=/dumpbd/PRUEBAS.backup
log=/dumpbd/PRUEBAS.log
>
> and after ten minutes, I get the next error:
>
> EXP-00002: Error to write file of exp
> EXP-00222:
> Error system 27
>
> The file have 2GBytes .
> The user what execute the exp have permissions
to make file > 2GB, and
> the file system ' Large File Enabled Journaled
File System', this is, is
> possible make
> file big.

May be exp use system call, that not support large file.

Try use exp with pipe.
For exmple:

mknod expdat.dmp p # Make named pipe
exp / full=yes file=expdat.dmp
log=/dumpbd/PRUEBAS.log & cat expdat.dmp > target_file

>
> What is the problem?
> Any help is appreciated.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 20 1999 - 13:04:21 CEST

Original text of this message