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

Here is Tom Kyte's response: "the documentation is in error, thanks-- one more to file when I get back :)"

So, I guess that's settle then. Whew! :-)

-----Original Message-----
From: Allen, Brandon
Sent: Wednesday, August 24, 2005 10:00 AM To: 'Mladen Gogala'
Cc: oracle-l
Subject: RE: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

Actually, the documentation does give *some* indication that the index maintenance portion is not "direct", although it's not very clear, and then clouded even further by the wording in the logging_clause section mentioned earlier:

(From http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c21dlins.htm#10696)

Index Maintenance with Direct-Path INSERT

Oracle performs index maintenance at the end of direct-path INSERT operations on tables (partitioned or nonpartitioned) that have indexes. This index maintenance is performed by the parallel execution servers for parallel direct-path INSERT or by the single process for serial direct-path INSERT. You can avoid the performance impact of index maintenance by dropping the index before the INSERT operation and then rebuilding it afterward.

I also found a thread on this same topic over at asktom.oracle.com (http://asktom.oracle.com/pls/ask/f?p=4950:8:16044210042548460889:::::) , and here is what Tom says:

"you have indexes on the table. indexes cannot be "appended" to, they must be modified. These modifications must be logged. The redo/undo for the table itself is not generated, the redo/undo for the INDEXES always is."

So, I've posted a note to the same thread asking Tom to confirm if there is a documenation bug.

Regards,
Brandon

-----Original Message-----
From: Mladen Gogala [mailto:gogala_at_sbcglobal.net] Sent: Wednesday, August 24, 2005 9:30 AM To: Allen, Brandon
Cc: oracle-l
Subject: Re: ORA-1578...block corrupted...error is normal...a block...had a NOLOGGING...operation performed against

On 08/24/2005 12:24:28 PM, Allen, Brandon wrote:
> 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").
>

Documentation is wrong when it mentions "direct inserts into index". There is no such thing.

-- 
Mladen Gogala
http://www.mgogala.com



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