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

Thread: export size vs database size

  1. #1
    Join Date
    May 2007
    Posts
    1

    Thumbs up export size vs database size

    hai

    my database size 45 gb
    than i taking full exporting data ....
    what is the size of export dump file?


    and "compress=y" means reduce size of export file???

    thanks
    dhana

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    "compress=y" will size the first extent in each table or index to be large enough to hold all of the data in one extent. Don't do it, having everything in one extent will not make it faster, it might cause more fragmentation though. Your export will be less than 45GB. how much less depends on how tightly packed the data is. Why don't you try an export and find out. If you are worried about having enough space for the export then you can pipe the export to gzip.

    [QUOTE=DHANADBA]hai

    my database size 45 gb
    than i taking full exporting data ....
    what is the size of export dump file?


    and "compress=y" means reduce size of export file???

    thanks
    dhana[/QUOTE]

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