删除oracle用户

two methods:

 

--星号用实际用户名称替换

1. drop user *** cascade;

 

2.

sqlplus '/as sysdba'
delete from user$ where name='***';
commit;
alter system flush shared_pool;