Re: How to Resize REDO LOG Files

From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: Tue, 16 Feb 1999 08:30:58 -0500
Message-ID: <7abs45$nsb@world6.bellatlantic.net>

The safest way is "Add and drop".

Take the entire DB offline,
drop the unused group,
create a new group with the desired size. Switch log files.

Do this for each group. When you are done you have dropped and re-created all your groups.

Dave B wrote in message <36C88E4D.641262F1_at_hotmail.com>...
>I have found out how to resize data files but cannot seem to find any
>information on how I can resize my REDO LOG files from their initial
>installation setting. Any ideas?
>
>Thanks in advance.
Received on Tue Feb 16 1999 - 07:30:58 CST