Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Index rebuild

Re: Index rebuild

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 27 Sep 2005 07:08:46 -0700
Message-ID: <1127830126.447840.120700@f14g2000cwb.googlegroups.com> 





Nick,  Any user with ALTER ANY INDEX can rebuild an index.  This would
include all users with the DBA role not just SYS and SYSTEM.



You cannot move a LOB index via an alter index statement.  The LOB
index goes with the table.  Check out the following link



http://www.freelists.org/archives/oracle-l/09-2004/msg01063.html



HTH -- Mark D Powell --
Received on Tue Sep 27 2005 - 09:08:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US