#/bin/bash

# Example Script to Import an Object from a Compressed Export File 
# without compressing it, by using FIFO (named_pipes)
# Use when uncompressing an export is not possible
# due to space and/or time constraints

# Declare the name of the named pipe

NAMED_PIPE=mypipe.pipe;

# Make the named pipe (FIFO)

mknod $NAMED_PIPE p;

# Use zcat to read compressed file and direct the standard out to the named pipe created earlier

zcat test_export.dmp.gz > $NAMED_PIPE &

# A sample imp using the named pipe

imp file=$NAMED_PIPE userid=test/test tables=(test_export) ignore=Y rows=Y;

# Remove the named pipe

rm $NAMED_PIPE;

# Exit the script

exit;