Re: dropping tables in a tablespace

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Tue, 21 Sep 1999 16:12:10 -0400
Message-ID: <MubnN0clbstmiC7Iw=27sg747qzf@4ax.com>

On Tue, 21 Sep 1999 15:29:50 -0400, Sudarshan Sampath <ssampath_at_scr.siemens.com> 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?

Are they all owned by 1 database user? If yes then...

drop user <username> cascade;

should do the trick. Then all you need to do is recreate the user and import.

hope this helps.

chris.

>
>Thanks,
>
>-Sudarshan

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 21 1999 - 15:12:10 CDT