Re: ORA-26028: index initially in unusable state

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: jdunn@xxxxxxxxx
  • Date: Thu, 20 Jan 2005 12:43:16 +0000

On Thu, 20 Jan 2005 11:56:31 -0000, John Dunn <jdunn@xxxxxxxxx> wrote:
> I am trying to understand why I get this error when using direct path
> sqlldr.
> There are no constraints on the table, just this index which is one field in
> the table.
> Why do I get this error?.
> The error text says
> Either rebuild the index, re-create the index, or use either
> but it is not clear to me which I should do. using the skip options seems
> easiest, but what are the implications of using any of the skip options?

The implications are that the index will remain unusable, but the data
will get loaded.

I'm not sure I see how ALTER INDEX REBUILD is particularly hard, do
you want the index to remain unusable and if so why do you not just
drop it?

Niall Litchfield
Oracle DBA

Other related posts: