创建用户(指定表空间)、删除用户
--创建用户(表空间已存在)
create user test identified by 123account unlockdefault tablespace orcl_datatemporary tablespace orcl_temp;
--删除用户
drop user username cascade;
--如果这个时候有活动的会话删除不了
select 'alter system kill session ' || '''' || sid || ',' || serial# || ''' immediate;' as "session"from v$session where username in ('USERNAME');