Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    7

    Cool Unanswered: How to check the DB size before doing the exp?

    Dear all,

    Before exp to dmp file, how can i check the DB size?

    For ex: the DB size is 1.3GB, after exp the dmp is it equal to 1.3G?

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think the exported data will be smaller in size, at least by the size of all indexes.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Oct 2004
    Posts
    4
    Hi,

    Export dump will be around 20 to 40 % of actual databse size. It depends on data stored in database (IF you have more BLOBS or LONG RAW then it will occupy more size).

    ALL the Best,
    Gitesh Trivedi
    Resource Database - DBAMETRIX Solutions

  4. #4
    Join Date
    Apr 2009
    Posts
    7
    Quote Originally Posted by giteshtrivedi
    Hi,

    Export dump will be around 20 to 40 % of actual databse size. It depends on data stored in database (IF you have more BLOBS or LONG RAW then it will occupy more size).

    ALL the Best,
    Gitesh Trivedi
    Resource Database - DBAMETRIX Solutions
    Get what you mean~

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    If you use Datapump there is an "Estimate" parameter that will make a best guess as to the size of the export file.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jan 2009
    Location
    Dhaka, Bangladesh
    Posts
    51
    you can use estimate parameter of expdp ... though it does not give you 100% correct size
    Mohammad Hasan Shaharear
    E-mail
    Blog: http://shaharear.blogspot.com

Posting Permissions

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