David-

Here's an example from the 9i docs...

ALTER INDEX ord_customer_ix REBUILD;

There are several variations so you might want to review your documentation prior to using it.

BTW- This the MSSQL group

Thanks
Chris



-----Original Message-----
From: David Neff
[mailto:mssqldba-ezmlmshield-x14736890.[Email address protected]
Sent: Friday, March 31, 2006 8:51 AM
To: LazyDBA Discussion
Subject: fully understanding that this is a SQL group,


does anyone know if you can rebuild indexes in Oracle on line without
impacting the users?



David Neff







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


MS Sql Server LazyDBA home page