Re: statement for dropping all objects of a certain user ?

In <336D1223.FCE_at_m.cc.utah.edu>, Bo Lu <bo.lu_at_m.cc.utah.edu> writes:
>Michael Agbaglo wrote:
>>
>> statement should be processable in sql-plus -thanks.
>
>User SQL*plus generate a *.sql script.
>"select 'drop ' || object_type || ' ' || object_name || ';'
>from all_objects where owner = 'xxx'".
>

Much simpler.

drop user USERNAME cascade;

Alex Filonov,

afilonov_at_pro-ns.net Received on Wed May 07 1997 - 00:00:00 CDT