Re: Resize log files

WANG SHIANG HUEY wrote:
>
> SQLDBA> ALTER DATABASE ORACLE DROP LOGFILE 'SYS:ORANW\DATABASE\WGLOG1.ORA';
> ORA-01623: log 2 is current log for thread 1 - cannot drop
> ORA-00312: online log 2 thread 1: 'SYS:ORANW\DATABASE\wglog1.ora'
> SQLDBA> ALTER DATABASE ORACLE DISABLE THREAD 1;
> ORA-01615: thread 1 is mounted - cannot disable
> SQLDBA> SPOOL OFF;
>
> --
> Shiang-Huey Wang
> Leather Center, Inc.
> sherry_at_leathercenter.com
> wshiang_at_a.cs.okstate.edu

You need to switch the log file which is the current one before dropping it. I think that the command for switch log file is " alter database switch logfile".

-- 
---------------------------
Bo Lu
Programmer/Analyst
Uiversity of Utah Hospital
bo.lu_at_m.cc.utah.edu
(801)-581-5964
---------------------------