Doubt: Changing datafile MAX SIZE on 188.8.131.52
Date: Wed, 6 Feb 2008 16:45:50 +0000
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 184.108.40.206(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.