Re: dropping tables in a tablespace

One of the options not mentioned yet by the other replies is to export the
tables, then import them with the destroy option turned on. Be VERY careful
that ALL tables etc. in the tablespace are being replaced though!

HTH. Pete

Sudarshan Sampath wrote:

> Hi folks,
> I am trying to do a fresh import of data into a tablespace. Right now
I
> want to
> get rid of all the tables (250 of them) in this tablespace as it I
want
> to import
> the tables afresh.
>
> How do I drop all tables in a tablespace? I know how to drop a
> tablespace...
> but that means I would have to create new tablespaces with the right
> parameters
> from the beginning. I want to be able to clear out all the data
(tables,
> indexes
> views....etc.) in a tablespace all at once. Is there a command to do
> that?
>
> Thanks,
>
> -Sudarshan

Received on Thu Sep 23 1999 - 07:00:24 CDT