Question on Archive Log

From: John Wood <jwood_at_hotmail.com>
Date: Tue, 10 May 2005 01:24:03 GMT
Message-ID: <T2Ufe.47110$vN2.44004@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 Received on Mon May 09 2005 - 20:24:03 CDT