import from a zipped file 1

[beechill4]

Hi,

i have a zipped oracle export file which i cannot uncompress because i have very little space on the disk

the file is called Jun292005.exp.Z

how can i import from this? can i even do this without uncompressing it?

 

[sem]

If you're on Unix, you may import it using FIFO

Regards, Dima

http://seminihin.narod.ru

 

[LKBrwnDBA]

On *nix you can use pipes:

DMPFILE=Jun292005.exp.Z
IMPP=/tmp/imp.pipe
mknod $IMPP p
imp / file=$IMPP parfile=imp.par ... &
cat $DMPFILE|uncompress -c >$IMPP

PS: Note the ampersand (&) at the end of the imp(port) statement.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb