Re: Doubt: Changing datafile MAX SIZE on 9.2.0.6

On Wed, Feb 6, 2008 at 1:01 PM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:

> Ricardo,
>
> You can do the same thing in Oracle 9i, 8i, 8 and probably 7.
>
> Tom
>

Yes, but there was at least one bug regarding 2G and 4G datafile sizes on MS Win 32 out there (in the minefield) that made things interesting. It was fixed long enough ago that I forgot the release/version affected.

Paul

> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ricardo Santos
> *Sent:* Wednesday, February 06, 2008 11:46 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Doubt: Changing datafile MAX SIZE on 9.2.0.6
>
>
> 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.
>

-- 
-----------------------------------------------------------------
USADA and WADA are broken and not worth fixing. Boycott professional sports.
Avoid patronizing their advertisers. Don't buy tickets to NBA, NFL, MLBB,
NHL and especially Pro Cycling.

--
http://www.freelists.org/webpage/oracle-l