Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXP ....FILE=(pipe to compress)
Calculating the size of an export file.
% mknod /tmp/exp_pipe p % exp file=/tmp/exp_pipe <other options> & % dd if=/tmp/exp_pipe of=/dev/null bs=1024
This will return the number of of 1K blocks the export file will be in the following format :
<no. of 1K blocks>+0 records in <no. of 1K blocks>+0 records out
Exporting directly to tape - an example
% exp userid=system/manager full=y file=/dev/rmt/0m volsize=145M
After EXP has written <VOLSIZE> to the tape, it will prompt for next:
Please mount the next volume and hit <ret> when you are done.
Exporting to tape via unix named pipes
% mknod /tmp/exp_pipe p # Make the pipe % dd if=/tmp/exp_pipe of=<tape device> & # Write from pipe to tape % exp file=/tmp/exp_pipe <other options> # Export to the pipe
Jorge Meirim wrote:
> Try www.oramag.com and the read one of the 2 flavours about this subject.
> (One use mkfifo and other one mknod).
> "This is not the fish... but intends to be the line and..."
> J. Meirim
>
> BJ Miller escreveu na mensagem <700heq$7th$1_at_cletus.bright.net>...
> >Hi,
> >
> >I have a problem at a customer site with EXP. They are unable to export to
> >disk due to filesize limitations (2G) and they are exporting to tape
> >(SLOW!). In researching possible solutions I read on a private newsgroup
> >that someone was able to 'pipe it to a compress', however EXP doesn't
> >exactly respond to the normal shell manipulations.
> >
> >Is there a way in Unix to specify an in-line compress?
> >
> >Thanks in advance,
> >
> >BJ
> >
> >
Received on Fri Oct 23 1998 - 18:37:41 CDT
![]() |
![]() |