oracle删除用户

--linux 查看剩余及使用空间
df -h


--查询用户的session:
select SID,SERIAL# from V$SESSION where username='OA_TEST210301';
--kill掉用户u1的session:
alter system kill session 'SID,SERIA#';
--查看所有用户
select * from all_users;
--查看用户及对应表空间
select username,default_tablespace from dba_users;
--删除用户
drop user OA_TEST210301 cascade;
--删除表空间
drop tablespace OA_TEST20210301 including contents and datafiles cascade constraints;