Re: delete database file on server -> sharing violation

<sybrandb_at_hccnet.nl> wrote in message
news:97nfh3h6l8e1s3ilfpb2ao7t6qf5a3i784_at_4ax.com...
> On Thu, 18 Oct 2007 13:25:45 -0400, "Greg D. Moore \(Strider\)"
> <mooregr_deleteth1s_at_greenms.com> wrote:
>
>>No, this is clearly one of those times when that would almost certainly
>>NOT
>>work.
>
> If it doesn't work, acknowledging the OP crossposted this to a
> sqlserver AND an Oracle forum. why flame an Oracle DBA instead of
> posting the correct response?

If correcting a wrong answer is considered flaming in the CDOS world then the more's the pity.

Add in the fact that DA Morgan has a history of posting inaccurate answers in the CDMS group, I felt it was important to correct his response before his advice potentially cost the original poster's company downtime and possibly money.

> Because you don't know the correct response?

Actually I know several possible routes, the DROP DATABASE is generally the best route. Unfortunately given original posters obvious lack of knowledge in this case, I suspect he'll need a bit more handholding to figure out where and how to do that.

Now a question for you, as you state with Unix (which snide comments about being blinded about), the inode will be held open until all access is complete (which btw, I think is NOT true in at least one distro of Linux as has been explained to me, which is just plain bad if true).

However, I would suspect simply deleting the files would cause error messages to show up when Oracle was restarted or the system was restarted? Most likely this would be non-fatal but as I prefer to run w/o errors, I'm curious as to the "correct" way to remove a database on a Unix system.

>
> --
> Sybrand Bakker
> Senior Oracle DBA

-- 
Greg Moore
SQL Server DBA Consulting           Remote and Onsite available!
Email: sql  (at)  greenms.com          http://www.greenms.com/sqlserver.html