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

Thread: EXP

  1. #1
    Join Date
    Oct 2001
    Posts
    127
    What is the maximum size for a export dump file.
    I am using Oracle 8.1.7 on Windows NT.
    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    its OS dependent.If your doing a export and you dont have sufficient space obiviously your export will stop.So its OS dependent.From oracle view point i guess there is not limit set.

    cheese
    anandkl
    anandkl

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    Generally 2 GB.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Oct 2001
    Posts
    127
    I do'nt thing 2GB is the limit as the size of my current export file is more than 4GB.

  5. #5
    Join Date
    Feb 2002
    Posts
    14
    export file can be of more then 2GB but while importing this generally gives problem.

    but any way if u want to export any such table , and you donot have sufficient space , u can use following trick to export in compress file.

    unix prompt> mknod /tmp/exportfile p

    unix prompt> compress < /tmp/exportfile > final.z &

    define export file name in ur parfile ( say parmfile) as /tmp/exportfile

    now

    exp parfile=parmfile .........

    yeah!!!

  6. #6
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    OS dependent but generally...
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

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