oracle删除用户及其名下对象

 drop user XXXX cascade;

drop tablespace XXXX INCLUDING CONTENTS;