drop user cascade,必须指定cascade以删除 system
时间: 2024-01-18 22:02:29 浏览: 187
回答: 是的,如果要使用DROP USER CASCADE命令删除system用户,必须指定CASCADE选项。CASCADE选项会删除与该用户相关的所有对象,包括表、视图、索引等。如果不指定CASCADE选项,系统会报错并拒绝删除system用户。
#### 引用[.reference_title]
- *1* [使用Oracle 闪回数据库恢复被删除的用户drop user cascade](https://blog.csdn.net/weixin_32026659/article/details/116321997)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [drop user cascade_快速回收表空间大小](https://blog.csdn.net/weixin_36147152/article/details/116525777)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]
阅读全文