Doubt: Changing datafile MAX SIZE on 9.2.0.6
From: Ricardo Santos <saints.richard_at_gmail.com>
Date: Wed, 6 Feb 2008 16:45:50 +0000
Message-ID: <34e16fec0802060845p3f4ca4e3s70630edd6caba87b@mail.gmail.com>
Date: Wed, 6 Feb 2008 16:45:50 +0000
Message-ID: <34e16fec0802060845p3f4ca4e3s70630edd6caba87b@mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 06 2008 - 10:45:50 CST