删除用户
drop user userName cascade;
删除表空间
drop tablespace tablespaceName including contents and datafiles;
删除临时表空间
alter database tempfile 'D:\app\liuxuan\oradata\orcl\tablespaceNameTEMP.DBF' drop including datafiles;
drop user userName cascade;
drop tablespace tablespaceName including contents and datafiles;
alter database tempfile 'D:\app\liuxuan\oradata\orcl\tablespaceNameTEMP.DBF' drop including datafiles;