Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP remote file using remsh
Scott wrote:
>
> I would like to do an import into a local database using a file on a
> remote server. Does import
> allow the pipe command. I've tried creating a symbolic link with ln -s
> remsh servername
This should work:
mknod /tmp/pipe p #MAKE A FIFO PIPE(rsh remote_site cat /var/tmp/exp.dmp) > /tmp/pipe #START A REMOTE CAT COMMAND TO A LOCAL
# FILE IN A SECOND WINDOW imp / full=y show=y file=pipe #START IMPORT rm /tmp/pipe #REMOVE THE FIFOPIPE mailto:brian.maclean_at_teldta.com Received on Mon Jun 16 1997 - 00:00:00 CDT
![]() |
![]() |