Drop a user's objects - Reply

From: Peter A. Udom <paudom_at_PTES.COM>
Date: Mon, 15 Jan 1996 10:49:29 -0500
Message-Id: <9601151552.AA22405@alice.jcc.com>

Kjetil;
U have probably thought of this but dynamic sql of type: connect as user who's objects are to be dropped select 'drop '||object_type, object_name from user_objects||';|| will probably fit the bill or have special reasons for not using dynamic sql??.

p

>>> 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 Mon Jan 15 1996 - 10:52:17 CST