drop user drop user cascade区别
1.oracle数据库中删除用户有两种命令，一种是 drop user xxx；另外一个种是drop user xxx cascade;
2.官方的说明如下：
点击(此处)折叠或打开
- Dropping a Database User: Example If user Sidney\'s schema contains no objects, then you can drop sidney by issuing the statement:
- DROP USER sidney;
- If Sidney\'s schema contains objects, then you must use the CASCADE clause to drop sidney and the objects:
- DROP USER sidney CASCADE;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30060321/viewspace-1376038/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- SQL SERVER 2008 login failed 一例处理
- impdp ORA-39166 Object was not found
- 分区表之局部索引的分区消除问题
- /etc/security/limits的中文解释
- 安装11g时ASM报错，Check if the DISPLAY variable is set
- Error "TNS-12518: TNS:listener could not hand off client connection"
- Oracle'sRedoLog
- aix mount "vmount: Operation not permitted." Error From NAS NFS
- 全库导出时报 ORA-39125 ORA-04063 view "SYS.KU$_CLUSTER_VIEW" 有错误
- Heap size 2814K exceeds notification threshold (2048K)
