Results 1 to 5 of 5

Thread: Reorg

  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Wink Unanswered: Reorg

    I'm planing to reorganize some tables in my DB, and I'm not sure how to set the new storage clause.
    If I have a table with 512kb, do I have to set the ONE init_extent of 512kb, in order to have all data contiguous? ok?
    What if the table size is, for example, >1G?
    Thaks in advance.

    Manf

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It depends.
    What evidence do you have that a reorg is actually needed?

  3. #3
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by anacedent
    It depends.
    What evidence do you have that a reorg is actually needed?
    some tables has more than 150 extents.

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    Originally posted by Manf
    some tables has more than 150 extents.
    switch to LMT locally managed tablespaces and you nearly never have to mind extents again ..

  5. #5
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by osy45
    switch to LMT locally managed tablespaces and you nearly never have to mind extents again ..
    Thanks!!!!

Posting Permissions

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