RE: ORA-26028: index initially in unusable state
- From: "John Dunn" <jdunn@xxxxxxxxx>
- To: "'Mark J. Bobak'" <mark@xxxxxxxxx>, <niall.litchfield@xxxxxxxxx>
- Date: Thu, 20 Jan 2005 14:17:49 -0000
<<I think the idea is to skip unusable indexes, do the load, then rebuild the
indexes w/ NOLOGGING. If you rebuild the index before the load, the index
maintenance will cause significant logging. It's faster and more efficient to
load while indexes are unusable>>
Thnaks for your comments, but rebuilding the indexes takes far longer than the
time saved during the load, even with nologging!
And it is still not clear to me what causes the index to become unusuable.
John
-----Original Message-----
From: Mark J. Bobak [mailto:mark@xxxxxxxxx]
Sent: Thursday, January 20, 2005 1:28 PM
To: niall.litchfield@xxxxxxxxx
Cc: jdunn@xxxxxxxxx; Oracle-L Mailing List
Subject: Re: ORA-26028: index initially in unusable state
I think the idea is to skip unusable indexes, do the load, then rebuild the
indexes w/ NOLOGGING. If you rebuild the index before the load, the index
maintenance will cause significant logging. It's faster and more efficient to
load while indexes are unusable.
-Mark
On Thu, 2005-01-20 at 07:43, Niall Litchfield wrote:
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?--Mark J. Bobakmark@xxxxxxxxx"Science is the belief in the ignorance of
experts." --Richard P. Feynman
--
//www.freelists.org/webpage/oracle-l
Other related posts:
