RE: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

Mladen, you also seem to be missing the point. You say the documentation is wrong - but then you go on to agree with it later in the same paragraph ("Oracle, as a matter of fact, allows you to bypass logging for speed").

We already understand that the indexes are not direct-path inserted like the heap table is. What we're discussing here is whether or not the (non-direct) index maintenance associated with a direct-path table insert is logged or not. The documentation says it is not logged if you CREATE/ALTER the index NOLOGGING, but as Jared and I have shown - the index maintenance, is actually fully logged, so the index is recoverable after the operation.

Also, what do you mean when you say "The NOLOGGING clause on an index will bypass logging but will significantly slow thing down, as the index will need to be rebuilt."?

How would NOLOGGING slow anything down and why would an index need to be rebuilt because of it? The only case I can think of is during recovery if you haven't backed up the tablespace since the creation of the index - but this should happen rarely, if ever (never happened to me in 7 years).

Regards,
Brandon

-----Original Message-----
From: Mladen Gogala [mailto:gogala_at_sbcglobal.net] Sent: Tuesday, August 23, 2005 6:07 PM
To: Allen, Brandon
Cc: Jared Still; oracle-l_at_freelists.org
Subject: Re: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

On 08/23/2005 08:11:10 PM, Allen, Brandon wrote:
> Here is another test indicating that a direct-path insert to a nologging index is actually logged (like Jared has also shown), which is contrary to the documentation.

Documentation is plain wrong here.

 . . .

Oracle, as a matter of fact, allows you to bypass logging for speed.

. . .

The NOLOGGING clause on an index will bypass logging but will significantly slow thing down, as the index will need to be rebuilt.

 . . .

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l