Re: changing redo log file size ?

vertigo wrote:

> hello
> is it possible to change redo log file size ?
> If yes how ?
>

No it's not.

To effect a change in size, you simply have to add new logs of the new size, and then drop the old logs of the old size.

Just bear in mind that you cannot drop a log which is CURRENT or ACTIVE. Therefore, 'alter system switch logfile' is your friend.

Regards
HJR Received on Sat Oct 23 2004 - 09:55:20 CDT