Is is safe to drop an empty tablespace?
From: <genegurevich_at_discover.com>
Date: Thu, 27 Mar 2008 08:48:23 -0500
Message-ID: <OF374BE25C.9B58C8E8-ON86257419.004B9D02-86257419.004BD82A@discover.com>
Date: Thu, 27 Mar 2008 08:48:23 -0500
Message-ID: <OF374BE25C.9B58C8E8-ON86257419.004B9D02-86257419.004BD82A@discover.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2008 - 08:48:23 CDT