No problem, I simply would like to clear the question.
Thanks for the information about
Alexander
Sybrand Bakker <postbus_at_sybrandb.demon.nl> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ:tkgu0dfp5b9kb0_at_beta-news.demon.nl...
> Exactly!
> Only 2 commands instead of 1.
> Of course you may also need to switch the logfile because you obviously
> can't do anything with a current logfile, nor drop nor resize.
> As resizing online redo logfiles occurs only very infrequently I don't see
> what the problem is with running two commands instead of one.
> Put them in a script with proper parameters and that's it.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
> "Alexander V. Silantiev" <silantiev_at_bashkortostan.ru> wrote in message
> news:9i9pbu$84d$1_at_poikc.bashnet.ru...
> > 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 - 21:46:04 CDT
