Copying a 22Gig partition from Production to Development - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Copying a 22Gig partition from Production to Development

  1. #11
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    A 22gig direct export of a table partition is taking 10 hours. Surprisingly the dmp file size is 32GB. How so? When I gzipped it it shrunk to 3GB.

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    your system is slow

    I have exported several +200 gb size database under 5 hours and the i/o system werent 100% optimized

  3. #13
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    Production database is 6.5T. 18CPU. Memory 56G. Oracle 9.2.0.5. We are not there on 10g - hence can not use data pump. There are users the batch jobs while export is going on.

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I did not use data pump neither

  5. #15
    Join Date
    Mar 2002
    Posts
    534
    how long does a insert parallel via db link take?

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