Re: Dropping Online Log Files

Chuck Carson wrote:
>
> I currently have 5 groups of redo logs and want to reduce this to only
> 2. How can this be achieved? I am running 9.2.0.1 on Solaris 8.
>
> Thanks,
> CC

alter database drop logfile group n;

Is there any problem with having 5 ?

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"