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 -> Rebuild implicit index for primary key

Rebuild implicit index for primary key

From: Franz Kruse <Franz.Kruse_at_t-online.de>
Date: Fri, 5 Jan 2007 23:26:56 +0100
Message-ID: <enmjb6$t6g$02$1@news.t-online.com> 





I converted a LONG column in a table to CLOB. This caused an implicit 
index for the primary key to be set to unusable state. Is there a way to 
rebuild the index without explicitly mentioning its name? Both the 
conversion LONG to CLOB and the rebuild are in an SQL script where the 
name of the index is not known. - Or is there a way to avoid the 
unusable state when converting the LONG column?



Any hint is welcome.



Franz
Received on Fri Jan 05 2007 - 16:26:56 CST












Original text of this message













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