On Oct 15, 3:15 pm, gazzag <gar..._at_jamms.org> wrote:
> 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
Thanks very much. The tablespace wasn't being used - but needed to
check before I dropped it.
Barry
Received on Mon Oct 15 2007 - 09:29:51 CDT
