Export to the compressed file
/etc/mknod my_own_pipe p
gzip -c -9 < my_own_pipe > mydump.gz &
exp username/password ...... file=my_own_pipe
rm -f my_own_pipe
Import from the compressed file:
/etc/mknod my_own_pipe p
gunzip -c mydump.gz > my_own_pipe &
imp username/password ....... file=my_own_pipe
rm -f my_own_pipe
The following trick could be used, if You want to start Oracle export as sysdba: use double quotes around the single quotes.
Warning! Dump consistency could not be guaranteed, if the export is done under sys user!
exp userid=" '/ as sysdba' " parfile=exp.par
Possible parameter file:
file=mydump.dmp
compress=n
log=mydump.log
direct=y
full=n
owner=SCOTT
consistent=y
feedback=10000