Re: deleting all database objects belonging to a user
From: Ramesh K Meda <74053.36_at_CompuServe.COM>
Date: 1995/11/29
Message-ID: <49gmnc$sru$3_at_mhafn.production.compuserve.com>#1/1
Date: 1995/11/29
Message-ID: <49gmnc$sru$3_at_mhafn.production.compuserve.com>#1/1
Run following query under the user
select 'Drop ' || object_type || ' ' || object_name || ';'
from user_objects;
This is called meta-scripting.