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 -> Unusable Index problem

Unusable Index problem

From: Jerome Chik <jerome.chik_at_citec.com.au>
Date: Wed, 19 Jan 2000 14:28:43 +1000
Message-ID: <38853D7A.9D04F357@citec.com.au> 





Hi,



I'm wondering what would cause an index to be unusable and how do I
avoid this?



It seems to happen after I do a data load with sql*loader using a direct
path method.  Once the data is loaded, certain indexes become unusable.



Using a 8.1.5 database.



Thanks,



Jerome.


Received on Tue Jan 18 2000 - 22:28:43 CST












Original text of this message













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