Oracle Database Export and Import compressed

Export

#!/bin/bash

$username=<username>
$password=<password>
$exportfile=<importfile>
$exportlog=<importlog>
$DBNAME=<dbname>

mknod pipe p

cat pipe |gzip -c >$exportfile &
exp $username/$password@$DBNAME file=pipe DIRECT=Y CONSISTENT=Y LOG=$exportlog
sleep 5

rm pipe

 

Import

#!/bin/bash


$username=<username>
$password=<password>
$importfile=<importfile>
$importlog=<importlog>
$DBNAME=<dbname>

mknod pipe p

gunzip < $importfile > pipe &
imp $username/$password@$DBNAME file=pipe DESTROY=Y FULL=Y IGNORE=Y LOG=$importlog
sleep 5

rm pipe