Re: How To Turn Archive Off

From: Kristina Sjögren <sjoegren_at_algonet.se>
Date: Thu, 3 Jun 1999 21:54:10 +0200
Message-ID: <7j6nim$g9f$1@cubacola.tninet.se>

Hello!
Following steps will work for Oracle 7 on Windows NT4;

1) start svrmgr23.exe or dbsmgr.exe
2) connect internal/password
3) shutdown (if database are up)
4) startup mount
5) alter database noarchivelog    "here you can decide

archivelog/noarchivelog"
6) alter database open
7) exit

Martin

Snow Tracks skrev i meddelandet ...
>Hi. We sometimes develop against Oracle databases.
>
>Currently, in my \orant\database\archive directory are about 600 files.
>
>Does anyone know how I can turn off archiving?
>
>Since we just have development DBs, we have no need for archiving.
>
>I tried setting 'log_archive_start' to 'false' in init.ora with no apparent
>effect.
>
>Are there any other steps I need to take?
>
>Thank you,
>st
>
>
>
>
Received on Thu Jun 03 1999 - 14:54:10 CDT