In our 9206 environment,
Most of our datafiles are link.

When we drop the datafiles/tablspace included content using OEM console,
The link file was deleted, but not the file. We have to manually get to
the location of the files and removed it.
I think it is the same using sqlplus.

Thanks,


------------------------------------------------------------------------
----
David Chiu

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x55491961.[Email address protected]
Sent: Friday, October 28, 2005 4: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