Re: Help: drop tablespace

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

sigdock_at_my-deja.com wrote:
>
> If I'm right you have to shutdown the instance first. Then you can
> delete the datafile and restart.
>
> h.t.h.
>
> BertJan Meinders
> Oracle DBA
> ASR-ICT
>
> In article <969370609.834837_at_newsreader-hpw1.net.bms.com>,
> "sc" <cfs3526_at_hotmail.com> wrote:
> > Hi, folks,
> > After I drop the tablespce I just created, I can not delete the
 datafile, I
> > always got an error message saying "sharing violation, the source or
> > destination maybe in use", could someone tell me how can I delete the
 file
> > so I can recreate the tablespace using the same script?
> >
> > Thanks for your help
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================