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;