Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop tablespace

Re: drop tablespace

From: gazzag <gareth_at_jamms.org>
Date: Mon, 15 Oct 2007 07:15:32 -0700
Message-ID: <1192457732.778737.274890@v29g2000prd.googlegroups.com>


On 15 Oct, 15:14, gazzag <gar..._at_jamms.org> wrote:
> 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

Apologies. The query above should be:

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US