Re: Help: drop tablespace

From: Adrian Shepherd <hashman_at_bigpond.net.au>
Date: 2000/09/20
Message-ID: <um3y5.692$Z06.6502@news-server.bigpond.net.au>#1/1

I've seen this on NT, Oracle won't release the locks on the deleted datafile until the instance is restarted, that was way back in 7.3.4 though...

"jgroff" <jgroff_at_email.msn.com> wrote in message news:uOAPS$vIAHA.233_at_cpmsnbbsa07...
> What OS? I've done this numerous times on HP-UX without incident.
>
> sc wrote in message <969370609.834837_at_newsreader-hpw1.net.bms.com>...
> >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
> >
> >
>
>
Received on Wed Sep 20 2000 - 00:00:00 CDT