create  bigfile tablespace 表空间名 datafile ‘/xxx/xxx/xxx.dbf’ size 100m autoextend on next 1024m nologging;

create user 用户 identified by 密码
	default tablespace 表空间名
	temporary tablespace temp;
	profile default;

drop user 用户名 cascade;

drop tablespace weishu_tbs including contents and datafiles;

select t.USERNAME,t.SID,t.SERIAL#,t.STATUS from v$session t where lower(username)='XXX';

alter system kill session '822,8993'

drop user weishu cascade;