Home > Database > Mysql Tutorial > Oracle中删除用户遇到的问题

Oracle中删除用户遇到的问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-07 17:20:03
Original
1092 people have browsed it

新建了一个用户xy,并导入了一些表,序列,存储过程在其中。现在我用删除该用户 出现问题 执行drop user xy,报错ORA-01922: 必

新建了一个用户xy,并导入了一些表,,序列,存储过程在其中。现在我用删除该用户

出现问题

执行drop user xy,报错ORA-01922: 必须指定 CASCADE 以删除 'XY'

问题原因

CASCADE众所周知是级联的意思,说明删除该用户要先删除与之相关或者级联的信息

解决办法

drop user xy cascade

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template