no...just make sure you have enough room on the volume where the file is
located...

-----Original Message-----
From: Anandhi Narayanswamy [mailto:[Email Address Removed] Thursday, February 26, 2004 10:26 AM
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
Oracle LazyDBA home page