Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie
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