Is is safe to drop an empty tablespace?

From: <>
Date: Thu, 27 Mar 2008 08:48:23 -0500
Message-ID: <>

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

Received on Thu Mar 27 2008 - 08:48:23 CDT

Original text of this message