Oracle中dropuser和dropusercascade的区别

转 Oracle中 drop user 和 drop user cascade 的区别https://blog.csdn.net/tianlesoftware/article/details/5656930drop user ： 仅仅是删除用户，
drop user ×× cascade ：会删除此用户名下的所有表和视图。

user
Specify the user to be dropped. Oracle Database does not drop users whose schemas
contain objects unless you specify CASCADE or unless you first explicitly drop the
user's objects.

CASCADE
Specify CASCADE to drop all objects in the user's schema before dropping the user. You
must specify this clause to drop a user whose schema contains any objects.

使用cascade参数可以删除该用户的全部objects。要说明的如下：

1 . If the user's schema contains tables, then Oracle Database drops the tables and automatically drops any referential integrity constraints on tables in other schemas that refer to primary and unique keys on these tables.
如果用户的schema中有表，则在删除表的时候自动删除与该表相关的主键和外键。

2 . If this clause results in tables being dropp