Re: Insert /* +append */ always ?

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:addtbq02m2j_at_drn.newsguy.com

>
> What that means is that the data need no be protected by REDO in noarchivelog
> mode. We don't need to redo the operation since the operation is done directly
> to disk. Since media recovery is not possible in noarch mode -- no redo is
> needed (we don't need the redo for instance recover in these cases since the
> blocks are already safely on disk)
>
> In archivelog mode, we do need the redo and the operations would have to be
> performed on NOLOGGING tables in order to bypass redo generation....
>

Hi Tom,

I tested that rows inserted by append hint does appear after a database recovery. But I have a question: If we have a hot standby database,
does the standby database also gets those records? If not the standby will silently gets corrupted.
I am talking of Oracle 8i and above versions. Thanks for guiding us,
Saikat
http://saikatchak.tripod.com

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG