I think what 10g means is when you drop or remove datafiles/tablespaces it also cleans the files physically which was not the case in earlier versions at least until oracle 8i. I am not sure about 9i.

Gurmohan
www.onlymath.com - The place for learning and teaching math.



-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x52158867.[Email address protected]
Sent: Friday, October 28, 2005 12:41 PM
To: LazyDBA Discussion
Subject: Oracle 10G Database Release 2


To All,
I was told that you can now drop "empty" datafiles in Oracle Database 10G Release 2. Does that mean logically and physically or just logically? Thanks for you support!



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page