Oracle-L: Re: Drop a user's objects

From: TSAWMILL.US.ORACLE.COM <TSAWMILL_at_US.ORACLE.COM>
Date: Tue, 16 Jan 1996 09:17:49 -0500
Message-Id: <9601161455.AA15169@alice.jcc.com>

--Boundary-7846256-0-0

Any DBA worth his salary will tell you that it is, in the least, not a good idea to attempt to update sys or system objects. You are only asking for trouble. Stick with the conventional methods.

Tim Sawmiller
tsawmiller_at_us.oracle.com
"I speak for me and no else!"

--Boundary-7846256-0-0
Content-Type: message/rfc822

Date: 16 Jan 96 10:44:00
From:"Subramaniam, Sridhar" <SSubrama_at_NIBUCORP.CCDN.OTC.COM.AU> To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_CCVM.SUNYSB.EDU Subject: Re: Drop a user's objects - Reply Reply-to: ORACLE-L_at_CCVM.SUNYSB.EDU
X-Orcl-Application: Sender: "ORACLE database mailing list." <ORACLE-L_at_CCVM.SUNYSB.EDU>
X-To: Reply Oracle SIG <ORACLE-L_at_CCVM.SUNYSB.EDU>

You could delete from sys.obj$ where owner# = owner id ( get this from sys.user$ table ). Be very careful in doing this. You will need to bounce the db to get this to work.

Sridhar Subramaniam
Telstra Corporation
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au

avion_at_ozemail.com.au

>>> Kjetil Nordstrand <kjetil.nordstrand_at_KVAERNER-PULPING.SE> 01/13 6:03
am >>>
Folks,

is there a fast way to drop all the database objects of one specific user WITHOUT dropping the user itself ? This would save me a lot of time on regenerating database objects from Designer/2k.

/Kjetil

Kjetil Nordstrand, Kvaerner Pulping Technologies AB, Karlstad, Sweden Internet: kjetil.nordstrand_at_kvaerner-pulping.se "We choose to go to the moon in this decade and to do the other things, not because they are easy, but because they are hard"

                                      John F. Kennedy
*********************************************************************

--Boundary-7846256-0-0-- Received on Tue Jan 16 1996 - 09:55:47 CST