Re: drop tablespace

From: gazzag <gareth_at_jamms.org>
Date: Mon, 15 Oct 2007 07:14:43 -0700
Message-ID: <1192457683.005318.306560@i38g2000prf.googlegroups.com>

On 15 Oct, 15:06, Barry Bulsara <bbulsar..._at_hotmail.com> wrote:
> 10.2 RHEL
>
> Hi, could someone point me in the right direction for finding out all
> tablespaces being used for a given user.
>
> When our DB was created, someone just assigned users to default users
> tablespace and it got very very large. We have manually reassigned
> tablespaces for all users now and want to drop the default users
> tablespace. Before we do this, we want to check that this is not the
> default tablespace for any users.
>
> Thank you
> Barry.

select owner, tablespace_name, count(*)
from dba_segment
group by owner, tablespace_name

HTH -g Received on Mon Oct 15 2007 - 09:14:43 CDT