problem with Index rebuild
How can I rebuild the indexes online,after trucating/moving partitions tables,so that things has not come in unstable stage and continue keep responsing on same tables. As
rebuild takes several minutes. So how could I manage the things when database is online with out interuption.
Software/Hardware used:
Software/Hardware used:
ASKED:
May 20, 2005 2:15 PM
UPDATED:
June 13, 2005 2:39 AM
Answer Wiki:
Hi,
you can use
alter index <name> rebuild online;
you need the same amount of space again, because oracle creates a tempory index!
It is still a good idea to rebuild the index when not much work is going on.
It does not work with bitmap or clustered indexes.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
