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@xxxxxxxxxxxxx]
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

Other related posts: