drop user drop user cascade区别

1.oracle数据库中删除用户有两种命令，一种是 drop user xxx；另外一个种是drop user xxx cascade;

2.官方的说明如下：

点击(此处)折叠或打开

1. Dropping a Database User: Example If user Sidney\'s schema contains no objects, then you can drop sidney by issuing the statement:
2. DROP USER sidney;
3. If Sidney\'s schema contains objects, then you must use the CASCADE clause to drop sidney and the objects:
4. DROP USER sidney CASCADE;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30060321/viewspace-1376038/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30060321/viewspace-1376038/