Nope, whether is resize as in decrease size or increase size...
Oracle won't allow to decrease below the HMW...so you are OK

PS: always make a backup doing anything as that...

Regis



-----Original Message-----
From: Anandhi Narayanswamy [mailto:[Email Address Removed]
Sent: 26 February 2004 15:26
To: LazyDBA.com Discussion
Subject: resize system tablespace

Is there any pitfall associated with using this
command:

alter database datafile '.../system.dbf' resize 512M;

Thanks
Anandhi

__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page