Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Export Fails=Help

Re: Export Fails=Help

From: Michael Zhang <zhangliuqing_at_hotmail.com>
Date: Thu, 8 Jul 1999 19:27:49 -0400
Message-ID: <Ytah3.153$Ay3.196390912@momma.bigmomma.com>


Hi:

First to check if OS filesystem has a 2G file size limit, if no, do export this way:
mknod -p work_pipe
exp user/pass_at_inst direct=y full=y file=work_pipe log=/d1/log.txt & dd if=work_pipe of=/d5/oracle/export.exp.

Good lucy.

Michael.

Scott Hahn <scotty_at_superior-sdc.com> wrote in message news:31ah3.1632$c85.17653_at_server1.news.adelphia.net...
> Hello-
> My environment,
> Oracle 7.3.4, AIX 4.2
> Problem
> My export seems to fail as it reaches two gig. command = exp
> user/pass_at_inst direct=y full=y file=/d5/oracle/export.exp log=/d1/log.txt
>
> the export fails claiming "Cannot write to export file" At that point the
> file size is by using ls -s 2097814 which if I am not mistaken is 2 gig
>
> Now I have all ulimits set to -1 which gives the oracle user unlimited
file
> size, or so I think. Also the /d5 logical drive was created to support
> large files.
>
> Does anyone know how to work around this?
>
> I need help from someone who knows IBM's AIX specifically to confirm these
> things? Does anyone know how to confirm from the shell that 1) the user
> oracle has unlimited file size 2) That the /d5 logical drive supports
large
> file sizes?
>
> If anyone can help me I would GREATLY appreciatte it. I am pretty lost.
>
> In addition can someone please tell me how I can export directly to tape
if
> my tape drive is /dev/rmt0
>
> You can see I am not much of a UNIX admin
>
> Scott Hahn
> scotty_at_superior-sdc.com
>
>
>
>
Received on Thu Jul 08 1999 - 18:27:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US