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

Home -> Community -> Usenet -> c.d.o.server -> recreate all indexes on <tablename>

recreate all indexes on <tablename>

From: howard <pkowal74_at_gmail.com>
Date: 12 Sep 2006 11:23:31 -0700
Message-ID: <1158085411.333754.54670@d34g2000cwd.googlegroups.com> 





Hi,



I've been asked by Oracle support to drop and recreate all the indexes
on a table to deal with a ORA-600 error.



Now, how would the database know what to re-create if I had just
dropped the index?



Do I just run "recreate all indexes on <tablename>" after I have
dropped them?



Thanks,



Howard
Received on Tue Sep 12 2006 - 13:23:31 CDT












Original text of this message













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