create user tms identified by tmsneu;
grant connect,resource,dba to tms;
commit;
select * from USER_TABLES where table_name like 'UP_%';
select 'drop table '||table_name||';'
from cat
where table_type='TABLE';
//完全删除
select 'drop table '||table_name||' cascade constraints purge;' as sqlscript from user_tables;