Write very small script like:
spool del_objects.txt
select 'drop '||object_type||' '||owner||'.'||object_name||';'
from all_objects
where owner = 'UR_USER';
spool off;
or use dynamic sql for it.
|
Results 1 to 10 of 18
Threaded View
|
Click Here to Expand Forum to Full Width |