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
> SKIP_UNUSABLE_INDEXES or SKIP_INDEX_MAINTENANCE (Sql*Loader only).
>
> 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
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
