Re: Oracle Archive Directory

You have to first make sure the database is on the mount state, not open. Then issue the following command 'alter database noarchive;'. This will take the database out of archive log mode. You should then and only then change the init.ora to 'log_archive_start = false'.

Good Luck
Javier

Snow Tracks wrote:
>
> 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 effect.
>
> Are there any other steps I need to take?
>
> Thank you,
> st
Received on Fri Jun 04 1999 - 01:32:16 CEST