Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exporting Directly to Tape
I did not work on the actual scripts, but did take part in the design.
What I believe you want to do is export to a named pipe (mkfifo) in the
background. You then have another process to read from the named pipe
and pipe (|) the output to the tape.
Something like this may work (we currently use this strategy to exp 'directly' to a compressed file):
mkfifo /tmp/NAMEDPIPE
exp user=userid/passwd parfile=$PARFILE file=/tmp/NAMEDPIPE &
cat /tmp/NAMEDPIPE | tar -avf /dev/rmt/0mn
(check the tar command since we use the save command from networker)
Steven Seacord
Oracle DBA
>
> Has any one had any experience doing an export directly to dat tape on an
> HP-UX version 10.
>
> I specify the tape drive as the export location i.e. /dev/rmt/0mbd and
> export a few tables. Everything seems to work okay.
> I then re-wind the tape and copy the backup onto disk and try to do an
> import.
Received on Wed Dec 27 1995 - 12:10:52 CST
![]() |
![]() |