如何删除oracle 的用户及其数据

1.用sysdba登录

(1)cmd 控制台：sqlplus / as sysdba;

(2)drop user test cascade;

2.创建用户

-- Create the user 
create user test
  identified by test
  default tablespace hOTEL_DATA
  temporary tablespace temp;
-- Grant/Revoke role privileges 
grant dba to test;
grant connect to test;