Re: Help: drop tablespace

From: <sigdock_at_my-deja.com>
Date: 2000/09/20
Message-ID: <8q9q69$shr$1@nnrp1.deja.com>#1/1

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. Received on Wed Sep 20 2000 - 00:00:00 CDT