Re: Question on Archive Log

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 10 May 2005 02:15:07 GMT
Message-ID: <Xns9651C3D81E354SunnySD@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://downloadwest.
oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2012.htm#sth ref3299 Received on Mon May 09 2005 - 21:15:07 CDT