drop user user_name cascade;
drop
user
user_name
cascade
;
手动删除
select 'drop table '||table_name||';' from cat where table_type='TABLE'
select
'drop table '
||table_name||
';'
from
cat
where
table_type=
'TABLE'