Re: Newbie

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 12 Dec 2001 07:12:26 +1100
Message-ID: <3c16685a$0$559$afc38c87@news.optusnet.com.au>

drop tablespace blah including contents;

...will do the trick.

If any of those tables are parents of tables which have foreign key constraints, then it will have to be

drop tablespace blah including contents cascade constraints;

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Rayden" <durlecht_at_msu.edu> wrote in message
news:9v5o56$dgi$1_at_msunews.cl.msu.edu...


> Hey guys,

>

> I have created a tablespace and many tables. now i would like to delete

all


> the tables in that table space (tables contain indexes, foreign keys,

etc).


> i was wondering can i accomplish this buy just deleting the tablespace? or

> do i need to specifically go through and do drops....i guess what my

> question is.....does deleting a tablespace successfully remove all traces

of


> the tables with their keys, etc

>

>

> tom

>

>

Received on Tue Dec 11 2001 - 14:12:26 CST