Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: drop tablespace

Re: Help: drop tablespace

From: Yong Huang <yhuang_at_indigopool.com>
Date: 2000/09/20
Message-ID: <8qbc71$o20$1@news.sinet.slb.com>#1/1

Rebooting a server may be an overkill. You can install nthandle from sysinternals.com which tells you what program is holding what file open, just like lsof or fuser utility in UNIX. Then you can simply shutdown that particular program to delete the file. But sometimes even nthandle won't be any good. Then you need reboot.

Yong Huang
yhuang_at_indigopool.com

Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:39C8C5E6.A286E98A_at_edcmail.cr.usgs.gov...
> You do not have to shutdown the instance to delete a datafile from a
> dropped tablespace. Is this NT? Something else is most likely holding on
> to the datafile, but for the life of me I can't think of what it would
> be. You'll probably have to reboot your server.
>
> HTH,
> Brian
Received on Wed Sep 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US