Re: Resize redo logs

You'll need to drop them and recreate them with the required size. See Oracle DBA guide.

HTH,
Leng.
(lkaing at yahoo.com.au)

r406 wrote:

> Hi,
> I'm running Oracle 8i. I have 2 redo log groups (1 & 2), 2
> members each. Each member (.log file) is 500k, I want to
> increase them to 5m each. Since members in a group must be the
> same size, is there any easier way to do this other than create
> a group 3 & 4, drop groups 1 & 2, recreate 1 & 2, then drop 3 &
> 4? Thanks.
>
> -r
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Fri Mar 24 2000 - 00:00:00 CST