Re: dropping tables in a tablespace

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 22 Sep 1999 06:11:30 -0700
Message-ID: <37E8D582.56FB4630@us.oracle.com>

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 Wed Sep 22 1999 - 08:11:30 CDT