Re: alter system archive log stop;

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 02 Mar 2005 11:21:48 +0100
Message-ID: <d0443u$7k5$1@news.BelWue.DE>

Tof wrote:
[Snip]

>>
>> So, you're not on 10G, then?

>
>
> I am on 10g. There a difference between 9i and 10g ?

No they just changed the version out of greed ;-)

Check out the 10g Administrators Guide, Chapter 7.

Also:

sys_at_DEMO10G>select name, isdeprecated from v$parameter where name like 'log_arc%';

NAME                                                                             ISDEP
-------------------------------------------------------------------------------- -----
log_archive_config                                                               FALSE
log_archive_start                                                                TRUE	<--
log_archive_dest                                                                 FALSE

Finally, check out the SQL Reference on the archive log clause of alter system.

Cheers
Holger Received on Wed Mar 02 2005 - 04:21:48 CST