Import using compressed file

Hi,

I've an export dump file which is compressed & it's of size 20Gb,
the actual size of the file is 60GB,i don't have that much free space,

so i want to import using this dump file in the form of compressed itself,Is it possible to do like this?

Please if any one knows how to do this,please let me know.

This might help you.

http://www.tc.umn.edu/~hause011/code/exp-imp-db.ksh

type imp help=y

if there is any option which specifies about loading the compress files then it supports otherwise it not

On UNIX something like this should work; substitute uncompress with gzip or whatever:

Code:

---

$ mknod /tmp/imp_pipe p
$ uncompress < export.dmp.Z > /tmp/imp_pipe &
$ imp file=/tmp/imp_pipe

---

how about giving your .dmp a particular file size limit then specify different files spread out across your server?

Be easiest to use a pipe.