Export and Import activity using mknode option

This is the procedure for taking export/import where the dump files is in zipped format.
Where the space is issue.


To create node :
=================
mknod /tmp/ p

use gunzip or uncompress as below
================================
gunzip dump.gz /tmp/ &

Above commnad will not create any file and would not take space as well.

Now you can run export and import operations.
================================================

imp username/password file=/tmp/ log=imp.log



create nod :
=================
mknod /tmp/ p
mkfifo /tmp/case1228016node p

use gunzip or uncompress as below:
=================================
gunzip dump.gz /tmp/ &
gunzip < exp.20091203.1900.exp.gz > /tmp/case1228016nod &

Above command will not create any file and would not take space as well.


================================================
Now you can run export and import operations.
================================================

imp username/password file=/tmp/ log=imp.log


file = /tmp/case1228016nod
log = imp_copy.log
buffer = 10240000
userid = system/xxxx@dbanme
commit = N
fromuser =abc
touser = abc_COPY


nohup imp parfile=copy_import.par &
username/password file=/tmp/ log=imp.log