Home » RDBMS Server » Server Administration » rebuilding an index
rebuilding an index [message #62241] Tue, 06 July 2004 22:16 Go to next message
vadlamani
Messages: 39
Registered: November 2003
Member
How to rebuild an index fastly.
Is there any option like where the index is re-built using the existing index.
ALTER INDEX.. REBUILD USING...

thanks
vadlamani

Report message to a moderator

Re: rebuilding an index [message #62243 is a reply to message #62241] Wed, 07 July 2004 02:00 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

I think u urself has mentioned the solution for ur own problem. Means u can use ALTER INDEX IND_NAME REBUILD to rebuild an existing index. U can also use tablespace clause to move it to some another tablespace. And to make it fast u can rebuild it using parallel option.

Daljit Singh

Report message to a moderator

Re: rebuilding an index [message #62245 is a reply to message #62241] Wed, 07 July 2004 05:32 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
alter index NAME rebuild NOLOGGING
(nologging clause avoids writing records to redolog)

best regards...
www.otools.com.ar

Report message to a moderator

Previous Topic: Database Administration
Next Topic: inconsistent control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:20:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.