Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Remove all tables for user with one SQl statement?
>> 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
![]() |
![]() |