what to check before dropping a tablespace

I am going to drop a tablespace
and i want to sure the tablespace is empty before i really drop it i know i can query the dba_tables and dba_indexes to see if there is any table or index resides on this tablespace what else do i need to check?

also
i would like to know which user have privileges on this tablespace, and what privileges it is
so that i can create a new tablespace and assign those privileges to those users on the new tablespace
can anyone suggest me where to find these information?

thanks a lots

Regards,
Joe Received on Sat Sep 06 2003 - 11:37:56 CDT