Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: resizing of log files
And its still means that there is not the way of log file resizing without
droping and recreating its
with a different attributes?
Alexander
Daniel A. Morgan <dmorgan_at_exesolutions.com> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:3B486091.723BCA8F_at_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 - 09:06:46 CDT