Re: Is is safe to drop an empty tablespace?

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_at_discover.com <genegurevich_at_discover.com> 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
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l