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: drop user user_name cascade - question

Re: drop user user_name cascade - question

From: Tom Miskiewicz <miskiewicz2_at_no.spam.yahoo.com>
Date: Sun, 13 Oct 2002 21:41:00 +0200
Message-ID: <Z_jq9.14$Xn5.3781@news.ecrc.de>


> It's not really that difficult. You get the name of the segment from the
> first query I gave you, and then you issue the command:
>
> drop table fredtbl cascade constraints;
> drop index blah;
> drop cluster foo;
>
> ...or whatever other segment types you have listed.

BTW, I'm currently trying to drop the tablespace. It's 250MB big but the Enterprise Manager is thinking already since 2 hours... Can someone tell me, what the heck is going on with this box?

Thanks

Tom Received on Sun Oct 13 2002 - 14:41:00 CDT

Original text of this message

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