oracle删除用户

oracle查询链接情况

SELECT SID,SERIAL#,USERNAME FROM V$SESSION WHERE USERNAME='SONARQUBE';

oracle删除用户

DROP USER SONARQUBE CASCADE;

删除表空间

drop tablespace student including contents and datafiles cascade constraints ;

1、查询所有用户的表
select 'truncate table '||TABLE_NAME||';'
from all_tab_comments where owner in('HMCS_BUSINESS_DEMO','HMCS_LOG_DEMO','HMCS_SYS_DEMO','HMCS_DATA_DEMO') AND table_type='TABLE';

2、查询本用户的表
select 'truncate table '||TABLE_NAME||';' from user_tab_comments where table_type='TABLE' ;