problem in uncompressing

[prakashs43]

Slimdave ,

Thanks .... but , does this uncompress before doing the import .. ??
will the performance become slow while importing from compressed
file.

How can i test this script without importing to the database ?? I think we can do this using file == in imp par file .

am i missing anything .

#!/bin/ksh
rm -r /tmp/imp_pipe
mknod /tmp/imp_pipe
uncompress < FullExport.dmp.Z > /tmp/imp_pipe & sleep 3 $ORACLE_HOME/bin/imp file=/tmp/imp_pipe parfile=import.par