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: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 19 Dec 2005 18:19:56 GMT
Message-ID: <pan.2005.12.19.18.19.56.476078@sbcglobal.net> 





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.


-- 
http://www.mgogala.com


Received on Mon Dec 19 2005 - 12:19:56 CST












Original text of this message













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