Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Drop a user's objects - Reply
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
John F. Kennedy *********************************************************************Received on Tue Jan 16 1996 - 10:59:54 CST