Re: Importing direct from a compressed export ?

In article <47t9jo$1gv_at_nuscc.nus.sg>, med10054_at_leonis.nus.sg (NORHISHAM BIN MAIN) writes:
|> I know that one can do an export with compression on the fly using
|> named pipes. Is it possible to do the opposite ie. importing from a
|> compress file directly, using maybe named pipes again ?

yes, it is possible, assuming you're using a moderately modern UNIX:

	#!/bin/sh
	zcat expdat.dmp.Z | imp uid/pwd [other options] file=/dev/stdin

You will need to respond with a CR to the message from imp that complains about the filesize. You can automate this using the 'yes' command ... if you're on Solaris, get it from the FSF archives.

-- 
Names:	Bill Beaton			beatonb_at_cadvision.com
					Bill_Beaton_at_digitech.ab.ca
Phone:	(403) 295-3254 (Home)		(403) 266-8622 (work)