Re: 9:38:03 +0100

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 14 Jul 1999 17:04:19 -0400
Message-ID: <378CFB52.51548C31_at_bigfoot.com>


You can also export directly to the compress untility if you are on UNIX. look up the mknod command. This allows you to create a blocking pipe. You export to one end of it, and compress on the other end. In my experience, I get about a 5:1 ratio, so that that 10G would be your limit.

  • Dc.

Ted Linnell wrote:

> "Scott Hahn" <scotty_at_superior-sdc.com> wrote:
>
> >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
>
> 1) do a man ulimit.
> ulimit should show you the current max file size, can't remember
> the flag you need.
>
> Ted.
> ==============================================================
> | Ted Linnell <edlinnell_at_acslink.net.au> |
> | BSc GradDipDP CNA MACS PCP |
> | Nunawading, Victoria , Australia |
> ==============================================================
Received on Wed Jul 14 1999 - 23:04:19 CEST

Original text of this message