Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cannot delete datafile after droping tablespace for Oracle9i
"gazzag" <gareth_at_jamms.org> wrote in message
news:1133881855.328903.281560_at_o13g2000cwo.googlegroups.com...
> Your patch level would be useful too. What do you get if you try the
> following, as SYSTEM, at a SQL*Plus prompt?
>
> select banner from v$version;
>
> Linux does indeed handle file-locking very differently to Windows. I
> suspect that you would be able to delete the file at the O/S level. As
> a matter of interest, what does the following query return on your
> system?
>
> select name from v$datafile;
>
In my experience, it can take up to 1/2 hour before Windows/Oracle releases the lock on the file. No need to shutdown the instance.
-- Terry Dykstra Canadian Forest Oil Ltd.Received on Tue Dec 06 2005 - 09:43:48 CST