Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I drop schema objects?

Re: How can I drop schema objects?

From: Darin Pendergraft <dpendergraft_at_quests.com>
Date: Thu, 3 Jun 1999 11:34:21 -0700
Message-ID: <7j6hsv$55v@dfw-ixnews5.ix.netcom.com>


Be careful with this - you can do serious damage!

DROP USER USER_NAME CASCADE; Obviously you want to replace USER_NAME with the name of the user/schema that you want to get rid of.

Darin Pendergraft
Quest Software

Gennady <gennadyb_at_halcosoftware.com> wrote in message news:3756b7d0$0$3120_at_fountain.mindlink.net...
>Hello,
>How can I drop all schema objects which belongs
>to particular user using SQL statements?
>
>Gennady
>
>
Received on Thu Jun 03 1999 - 13:34:21 CDT

Original text of this message

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