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

Thread: Fragmentation

  1. 04-03-2004, 07:27 PM #1
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416

    Fragmentation

    If you move tables from a highly fragmented TS to a new TS which is LMT , then is it make us get rid of Fragments and no need to exp/imp? please explain.
    An ounce of prevention is worth a pound of cure
    Reply With Quote Reply With Quote
  2. 04-03-2004, 08:34 PM #2
    Mnemonical
    Mnemonical is offline Senior Member
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    The new TS wont be fragmented, but the old one will. See that the existing segment may have lots of small extents distributed across all over the old TS. After moving, there will be lots of new holes.

    F Melo.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width