Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

decrease maxsize for a datafile

user12158503Mar 19 2011 — edited Mar 19 2011

How do you decrease the maxsize for a datafile. If I have maxsize as 5G now, and I want to change it to 2.5G , do I do it by giving -

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf'
RESIZE 2.5G;

or

alter database datafile '/u02/oracle/rbdb1/stuff01.dbf' autoextend on maxsize 2.5G;

Can someone please help?

This post has been answered by Pierre Forstmann on Mar 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2011

Added on Mar 19 2011

#general-database-discussions

3 comments

8,327 views