Results 1 to 8 of 8

Thread: Reorg

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

    Unanswered: Reorg

    Hi.
    How could I identify that an object (table, tablesp) must be reorganize?
    After reorg a table, must I have to reorg the tablesp that contain it?
    Regards,

    Manf

  2. #2
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Can anybody give me a hand on this?
    Thanks in advance,

    Manf

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Not sure if this will help answer your specific problem, but it may be worth looking at...

    http://download-west.oracle.com/docs...a96533/toc.htm
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Here's a link that addresses the issue of table re-orgs:

    http://www.ipass.net/davesisk/oont_p...ce_storage.htm
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    what makes you think you need a reorg?

    Are you not using LMTs?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    That's exactly what Im trying to find out, a way to determine if I have to reorg an object.
    Here I have different DB and not all of them are using LMTs.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    search under this page for fragmentation:
    Code:
    http://www.dbaclick.com/modules.php?op=modload&name=News&file=index&catid=5&topic=&allstories=1
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Tnxs Duck.

    Manf

Posting Permissions

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