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

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Drop a user's objects - Reply

Re[2]: Drop a user's objects - Reply

From: Ken Friday <ken.friday_at_TELDTA.COM>
Date: Tue, 16 Jan 1996 08:59:13 -0600
Message-Id: <9601161559.AA30385@alice.jcc.com>

     Danger ! Danger !

     Could someone explain to me how this returns the extents to the
     available freespace pool ?

     Ken F.


______________________________ Reply Separator _________________________________
Subject: Re: Drop a user's objects - Reply Author: "ORACLE database mailing list." <ORACLE-L%ccvm.sunysb.edu_at_internet.teldta.com> at TDSMAIL Date: 1/16/96 10:44 AM

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
*********************************************************************

Received on Tue Jan 16 1996 - 10:59:54 CST

Original text of this message

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