Re: compression in a exp utility

What about going to tape through a FIFO named pipe? The steps we have are: # make the named pipe
mknod /tmp/exp_pipe p

# start compressing, direct output to tape drive (rmt0) compress </tmp/exp_pipe >/dev/rmt0 &

# run export. exp userid=$USER/$PASS full=y inctype=complete constraints=y file=/tmp/exp_pipe LOG=$LOGFILE volsize=0

This seems to work well enough. However if you are going to export through this sort of method be sure to test that you can import back through the pipe. Otherwise you are wasting your time.

In article <37131079.8506F39F_at_apk.net>,   Gary Gapinski <glg_at_apk.net> wrote:
> Hello, Falcioni:
>
> There are several ways to accomplish this.
>
> One can use a named FIFO for the output of the export, with a
> compression pipeline at the opposite end.
>
> I can't remember if it is available on AIX 4.1, but one can create a
> large-file-enabled JFS for files larger than 2GB. Don't forget to alter
> the ulimit fsize for larger files.
>
> If you upgrade to Oracle 8.1.5, its export utility can create multiple
> (smaller) export files.
>
> Regards,
>
> Gary
>
> Falcioni Francesco wrote:
> >
> > I'm searching for a certified utility like export that use a
> > compression algoritm. Because I'have file size problem on my OS (Oracle
> > 7.3.4 on AIX 4.1.5 )
> >
> > thanks
> > f_falcioni_at_aspes.it
> > DBA at ASPES Pesaro (Italy)
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 13 1999 - 10:21:06 CDT