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

Oracle LazyDBA home page