Re: dropping multiple tables belonging to a user

set pages 10000;
spo drop_table.sql;
select 'drop '||object_type||' '||object_name||';' from all_objects
where owner = '&owner'
and object_type = 'TABLE';
spo off;

Verna Legaspi <no.spam_at_host.net> wrote in message news:37F95236.3D614FFF_at_host.net...
> How do you drop multiple tables? Is it fairly simple? I just need to
> drop several tables that belong to a user. What's the best way to do
> this?
Received on Wed Oct 06 1999 - 04:01:32 CDT