Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: rebuild index online

    Hello,

    I have tried the rebuild index online and it seems to work ok.
    My question is, is there any penalty rebuilding online ? If not where is the catch, if any ?

    Thanks,

    Tal Olier (otal@mercury.co.il)

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118
    The catch is that transactions can keep going.

    The "penalty" is that it wil consume space in your temporary tablespace.

    Good luck.
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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