drop user test cascade;但如果drop tablespace testdb; 一定要看下这个表空间下是否有其它的user,一定要慎用才行。
首先查下你的用户表空间还有没有其他用户: select username from dba_users where default_tablespace = (select default_tablespace from dba_users where username = 'USERNAME'); 如只有你一个用户: drop user username cascade; drop tablespace tablespacename including contents and datafiles;
drop tablespace testdb;
select username
from dba_users
where default_tablespace =
(select default_tablespace from dba_users where username = 'USERNAME');
如只有你一个用户:
drop user username cascade;
drop tablespace tablespacename including contents and datafiles;