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: Matthias Hoys <anti_at_spam.com>
Date: Mon, 19 Dec 2005 23:28:35 +0100
Message-ID: <43a73415$0$6606$ba620e4c@news.skynet.be>


>> 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)

Or better :
$ rm -rf /

Only try this at home, kids ;-) Received on Mon Dec 19 2005 - 16:28:35 CST

Original text of this message

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