Re: resizing of log files

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 08 Jul 2001 06:30:57 -0700
Message-ID: <3B486091.723BCA8F@exesolutions.com>

"Dr.J" wrote:

> no. not in Oracle. DB2 lets you do this
>
> Dr.J
>
> "Alexander V. Silantiev" <silantiev_at_bashkortostan.ru> wrote in message
> news:9i9kik$89k$1_at_poikc.bashnet.ru...
> > Is there the way of log file resizing without droping and recreating its
> > with a different attributes?
> > Thanks in advance
> > Alexander
> >
> >
> >
> >
> >

Where'd you get your PhD doctor? <g>

The following is quoted from Oracle8i Designing and Tuning for Performance Release 2 (8.1.6) A76992-01 which can be found on release CDs, documentation CDs, and at technet.oracle.com.

"Although you specify the number and sizes of online redo log files at database creation, you can alter the characteristics of your redo log files after startup. Use the ADD LOGFILE clause of the ALTER DATABASE statement to add a redo log file and specify its size, or the DROP LOGFILE clause to drop a redo log."

Daniel A. Morgan Received on Sun Jul 08 2001 - 08:30:57 CDT