Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie

Re: Newbie

From: Uwe Schneider <uwe_at_richard-schneider.de>
Date: Tue, 11 Dec 2001 21:47:00 +0100
Message-ID: <3C1670C4.9040307@richard-schneider.de>


Rayden wrote:

> 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

Sometimes it is better to drop the owner of the objects in that tablepace : "DROP USER blabla CASCADE". That way you don't need to recreate the tablespace if you want to reuse it.

AFAIK Neither dropping a tablespace nor dropping a user really overwrites all bytes of the former objects.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!
Received on Tue Dec 11 2001 - 14:47:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US