Re: drop tablespace

From: Juan Carlos Rodriguez <juancarlos.rodriguez_at_terrassa.org>
Date: Tue, 19 Sep 2000 21:28:38 +0200
Message-ID: <8q8eki$g98$1@diana.bcn.ttd.net>

You can use the same file to create a new tablespace. Look CREATE TABLESPACE command at the SQL manual. You can do: CREATE TABLESPACE mytablespace DATAFILE 'myfile' REUSE;

Bye.

"sc" <cfs3526_at_hotmail.com> wrote in message news: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 Tue Sep 19 2000 - 14:28:38 CDT