Re: deleting all database objects belonging to a user

safer to DROP USER xxx CASCADE

--

In article <49gmnc$sru$3_at_mhafn.production.compuserve.com>, Ramesh K Meda
<74053.36_at_CompuServe.COM> wrote:



> Run following query under the user


> 

> select 'Drop ' || object_type || ' ' || object_name || ';'

> from   user_objects;

> 

> This is called meta-scripting.

> Send me mail if you need more help.