如何删除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;