Import using compressed file
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.
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:
$ 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?
Oracle it's not just a database it's a lifestyle!
BTW....You need to get a girlfriend who's last name isn't .jpg
Be easiest to use a pipe.
I remember when this place was cool.
Click Here to Expand Forum to Full Width