Re: Doubt: Changing datafile MAX SIZE on 9.2.0.6
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: saints.richard@xxxxxxxxx
- Date: Wed, 6 Feb 2008 09:57:54 -0800
Yes, you can change it online.
I do it occasionally (on 9i) to keep my lame maxextents report from getting
false hits.
Jared
On Feb 6, 2008 8:45 AM, Ricardo Santos <saints.richard@xxxxxxxxx> wrote:
>
> Hello to you all,
> first of all, sorry for such a dummy question, but ...
> I have a small doubt about changing the MAZ SIZE property of a datafile,
> on a database version 9.2.0.6(Windows 2003 Server): Can I change it with
> the system online (ALTER DATABASE DATAFILE 'E:\ORACLE\ORADATA\SOMETHING.DBF'
> AUTOEXTEND ON NEXT 1000M MAXSIZE 20000M;)? Or do I have to take any special
> caution ? On Oracle 10g, I know I can, because I already did it before, but
> on 9i ...
>
>
> Thanks for all your attention.
>
> Best regards,
> Ricardo.
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
