Re: Insert /* +append */ always ?

In article <adflck$nnu$1_at_lust.ihug.co.nz>, "Howard says...
>
>Of course it will not get them. Standby databases only get anything because
>the 'anything' first gets into the redo stream. If it doesn't get into the
>redo stream, the standby database doesn't get it.
>
>Do any nologgin operation, the standby is stuffed.

until 9iR2 of course when you can set the database to FORCE logging even if someone tries NOLOGGING

>
>HJR
>
>
>"Saikat Chakraborty" <saikatchak_at_hotmail.com> wrote in message
>news:ce53c312828ba02c6f9286612fdfbb6e.16981_at_mygate.mailgate.org...
>> "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
>
>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp