Posted by Greg D. Moore \(Strider\) on 10/20/07 04:41

<sybrandb@hccnet.nl> wrote in message
news:97nfh3h6l8e1s3ilfpb2ao7t6qf5a3i784@4ax.com...
> On Thu, 18 Oct 2007 13:25:45 -0400, "Greg D. Moore \(Strider\)"
> <mooregr_deleteth1s@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

[Back to original message]