Oracle Database Discussions

Hi,

I have some old users/schemas to clean up in a database I inherited

1 select distinct(owner), tablespace_name
2 from dba_tables
3* where tablespace_name like 'BO%'
SQL> /

OWNER TABLESPACE_NAME
------------------------------ ------------------------------
BO BOD
BO65 BOD
BO6_1A BOD


I want to clean out the other tablespaces but keep BO65 and all of its objects etc.
If I do a " drop user BO6_iA cascasde" (and hte smae for BO)- will it cleanly delete that user, but not touch anything inside BO65's schema?
(The effect of cascade is what I was concerned with).

Now lets's say I tried (by mistake) to drop BO6_IA! " including tablespaces and datafiles" .. would it give an error since it would be
in effect destroying a tablespace and file that is owned by another user (BO65) -- or would it just do it, and I would be out of luck for BO65?

Thanks in advance, also any pointers to good, clear docs would help.

Umfan866