Oracle 删除用户时出现异常ora-01922: CASCADE must bu specified to drop 用户名

create user hnrh identified by hnrh123;

 

Oracle 删除用户时出现异常ora-01922: CASCADE must bu specified to drop 用户名

Oracle 删除用户时出现错误ora-01922: CASCADE must bu specified to drop 用户名

drop uer 用户名:  时出现下边错误

ora-01922: CASCADE must bu specified to drop 用户名

drop user 用户名  cascade;

注意:

drop user xx ：只是删除用户

drop user xx cascade ：会删除此用户名下的所有表和视图

 

 

需要登录sys 超级管理员用户

select * from all_users;
select * from dba_users;


drop user MDSYS cascade;
drop user XDB cascade;
drop user XS$NULL cascade;
drop user WMSYS cascade;
drop user ORACLE_OCM cascade;
drop user OUTLN cascade;

alter trigger SYS.XDB_PI_TRIG disable;