Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporarily disable archive log
Hi Frank,
Shut the database, mount the database
issue
alter database noarchivelog;
alter database open;
and also make sure it is in restricted session mode, and you are really
the only one working.
Only in that case the 'hole' is acceptable.
Hth,
Sybrand Bakker, Oracle DBA
Frank Zuern wrote:
> Hello There,
> I have a test instance, which I am running in archive log mode.
>
> But from time to time I have to do a full import of one user which
> is owner of an application. So every time I do the import, I get
> houndreds and houndreds of Archive log files.
>
> I tried to disable archive log for this situation, but I failed.
>
> Neither alter database archive log disable nor
> outsigning of the entrys in the init-file worked.
>
> Can anyone help ??
Received on Wed Mar 03 1999 - 11:55:09 CST