Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rebuild Index 2
- Thread starter Moose467
- Start date
-
1
- #2
flstffatboy
Technical User
- Sep 19, 2002
- 84
What type of index are you rebuilding? A normal index can be rebuilt while the DB is online but it will lock that index during the rebuild phase and users will be unable to access it. If the index is a bit map you have to have the DB offline to rebuild.
FLSTF
FLSTF
-
1
- #3
Actually, the typical index can be rebuilt online. You do this by specifying "alter index index_name rebuild online". The old index structure continues to be available to other users during the rebuild.
It's true that bitmap indexes don't support online rebuilds. However, the entire database need not be offline to do the rebuild. Oracle will acquire the necessary locks, and other users will have to wait while the rebuild finishes. As a result, bitmap index rebuilds should typically be done in off-peak hours to minimize contention.
It's true that bitmap indexes don't support online rebuilds. However, the entire database need not be offline to do the rebuild. Oracle will acquire the necessary locks, and other users will have to wait while the rebuild finishes. As a result, bitmap index rebuilds should typically be done in off-peak hours to minimize contention.
- Thread starter
- #4
- Status
Similar threads