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: Remove all tables for user with one SQl statement?

Re: Remove all tables for user with one SQl statement?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 19 Dec 2005 14:10:15 -0800
Message-ID: <1135030202.313552@jetspin.drizzle.com>


Mladen Gogala wrote:
> On Mon, 19 Dec 2005 18:53:21 +0100, Matthias Hoys wrote:
>
>

>>Format C:

>
>
> He might be on a Unix system, like in the Jurassic Park. In that case,
> "format C:" is unlikely to work. He wanted to drop all user's objects,
> without actually dropping the user, and in a single command. I believe
> that "DROP DATABASE" fits the specs. Whether he actually wants it is
> another matter altogether. At any rate, there is no real danger. This
> command is available only in version 10.

And here I was thinking rm -r

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 19 2005 - 16:10:15 CST

Original text of this message

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