Re: Online redo logfiles

Redo logs cannot be altered, they can only be created via the CREATE DATABASE and ALTER DATABASE commands or dropped via the ALTER DATABASE command.

The ALTER SYSTEM SWITCH LOGFILE command is used to switch log files.

To change the redolog size you have to drop it and re-create it

1. check that the system is not using the redo log you are going to drop select * from v$log;
2. drop the redolog
3. recreate a bigger one

querix_at_my-deja.com wrote in article <7ukndj$ajn$1_at_nnrp1.deja.com>...
> I want to enlarge the size of the online redo logfiles. Can I do it
> with the 'alter database' command in a direct way?
> How?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Wed Oct 20 1999 - 10:58:33 CDT