Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between "drop user including contents" and "drop user cascade"?

marvin hechtJul 16 2010 — edited Jul 16 2010
Can anyone tell me the difference between "drop user including contents" and "drop user cascade"?

I have the following users. They are all in a tablespace called "bo"

bo
bo1
bo1_a
bo65

I want to keep user bo65 and all her objects, including (of course) the tablespace bo.

but I want to remove bo, bo1, and bo1_a. So will this be the proper command?

drop user bo cascade;
drop user bo1 cascade;
drop user BO6_1Abo cascade;

Or would I use "drop user including contents"?

Thanks in advance.

Dave.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2010
Added on Jul 16 2010
6 comments
14,097 views