DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Import using compressed file

  1. #1
    Join Date
    May 2006
    Posts
    41

    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.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2005
    Posts
    278
    type imp help=y

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

  4. #4
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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 

  5. #5
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  6. #6
    Join Date
    Jan 2001
    Posts
    3,134
    Be easiest to use a pipe.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width