You may want to verify that no one has quotas on this tablespace. select * from dba_ts_quotas where tablespace_name = 'BLAH'; Keep in mind that schema with UNLIMITED TABLESPACE (DBA Role, used to be resource in <10g) could also be using the tablespace. On 3/27/08, genegurevich@xxxxxxxxxxxx <genegurevich@xxxxxxxxxxxx> wrote: > > Hi Everybody: > > I am planning to drop an empty tablespace. I have confirmed that no user > has it defined as a default > (select distinct default_tablespace from dba_users), and no table/index > has > it defined as default > (select distinct def_tablespace_name from dba_part_tables/indexes). IS > there any other place > I should check to confirm that noone has this tablespace defined as > default > for any purposes? > > thank you > > Gene Gurevich > > > > -- > //www.freelists.org/webpage/oracle-l > > >