Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NOLOGGING and index

Re: NOLOGGING and index

From: Ales Voboril <alesv_at_post.cz>
Date: Thu, 18 Oct 2001 09:06:46 +0200
Message-ID: <9qlv0h$upc$1@ns.felk.cvut.cz>


Thanks for your reply, Tom.

>
> Yes, it makes sense when you think about it...
>
> The TABLE data is just written above the HWM. If we need to "rollback",
we just
> never advance the HWM.
>
> For the indexes however, a complex data structure, our new data is
intermingled
> with the old data. In the event of a rollback -- we have to be able to
UNDO all
> of the work we just did to that index.

Yes, it makes sense.

Then, the Oracle documentation is confusing at that point, isn't it?

Ales Received on Thu Oct 18 2001 - 02:06:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US