Re: How to delete datafile when the database is running on the N T

I run on NT since 7.1, now with 7.3.4. I did encounter that problem, but all
I had to do is wait a few minutes, and then the locks were gone and I could
delete the datafiles without shutdown of the database.

Sylvain Leclerc, DBA
sleclerc_at_magrit.com

> -----Original Message-----
> From: David Stien [SMTP:daves_at_rsc.co.uk]
> Posted At: Tuesday, February 16, 1999 7:58 PM
> Posted To: server
> Conversation: How to delete datafile when the database is running on
> the NT
> Subject: Re: How to delete datafile when the database is running
> on the NT
>
> Hi Dong,
>
> This is one of the "wonderful" features of running oracle on NT. At
> our
> work the only way we have found to accomplish this is to shutdown the
> db
> either immediate/normal from svrmgr23 and then stop the
> oracleservice(sid) and oraclestart(sid) from services in the control
> panel.
> Only then can you bin the file without causing a sharing violation.
>
> If anybody has found a way around his then i'd bee interested.
>
> Dave
>
> Senior Oracle DBA
> SAIC uk ltd.
Received on Wed Feb 17 1999 - 07:21:05 CST