Re: Question on Archive Log

Excuse my stupidity. I couln't find any info on 'alter session set ....' to disable archivelog for the cureent session. I could only disable the logging. But I think we couldn't disable logging for insert/update command as it is the basic Oracle features to recover Oracle database.

Please give me a little bit more idea.

Thanks.

JW

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns9651C3D81E354SunnySD_at_68.6.19.6...
> "John Wood" <jwood_at_hotmail.com> wrote in
> news:T2Ufe.47110$vN2.44004_at_clgrps13:
>
>> Hi there,
>>
>> Our Database system is using Oracle 9.2 on window 2000 servers. It is
>> running in Archive Log mode. I am not a dba, but as far as I know,
>> the Archive Log mode is a "System Setting"; all sessions' update will
>> run in that mode.
>>
>> But I was told that Oracle now support Archive Log mode by Session.
>> We can use "Alter Session ..." command to turn off the Archive Log for
>> the transactions made during the session.
>> Is this true ? Is this a new feature in 10g ?
>>
>> Please advise.
>>
>> Thanks.
>>
>> JW
>>
>>
>>
>
>
> Are you incapable or unwilling to RTFM?
>
> http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10750/toc.htm
>
> http://download-
> west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2012.htm#sth
> ref3299
Received on Mon May 09 2005 - 23:55:22 CDT