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

On Mon, 19 Dec 2005 23:28:35 +0100, "Matthias Hoys" <anti_at_spam.com> wrote:

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

And don't use this as an opportunity to test your backup and recovery strategy?

--
Sybrand Bakker, Senior Oracle DBA