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 ：会删除此用户名下的所有表和视图

评论

1 楼 yangguang111345 2013-06-20  

ORA-01922: CASCADE must be specified to drop 'username'

This error is issued if someone tries to drop a user when the user to be dropped still has objects. In order to drop the user and all his objects, use;
drop user user_name cascade;