alter index abc rebuild online;

11g new feature : index rebuild online.

In Oracle Database 11g, the online rebuild is truly online: it does not hold an exclusive lock. The DMLs are not affected.  It does so by tracking which blocks are being accessed and at the end merging these blocks with the newly built index.

No comments:

Post a Comment