difference between "drop user including contents" and "drop user cascade"?
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.