«  
  »

Oracle: export/import using compressed file

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
September 21st, 2009 | Tags: , , , , | Category: Oracle

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>