To All,
Thanks!


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


Same in 9i (including contents and datafiles).
Sabina.




"Shergill Gurmohan "
<oracledba-ezmlmshield-x98022766.[Email address protected]
10/28/2005 12:45 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Oracle 10G Database Release 2






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


--------
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