Ed,
Yes, I have experienced the same thing. I have to 1. conn sqlplus and
delete physical file like your example, or 2. go to OS and manually
delete the physical (which I do not recommend).
have a gggrrreeaattt weekend...
cs


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

To All,
I created a tablespace via the Enterprise Manager Console (EMC) GUI.
I then added a second datafile to that same tablespace. Then I dropped
the second datafile via the EMC with the check mark next to "include
associated operating system files". The second datafile was dropped
from the database but the associated datafile (operating system file)
was not deleted.

Then, I created a second tablespace via sqlpplus. Next, in sqlplus
also, I added a second datafile to this second tablespace. Last, I
dropped the second datafile using this command:

alter tablespace users drop datafile '/tmp/users01.dbf';


This worked! It deleted the second datafile logically and physically!


Have anyone else experienced this? Thanks for your 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