Path: news.easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!newsfeed.media.kyoto-u.ac.jp!news-west.eli.net!not-for-mail
Message-ID: <3CFFD173.9ABB00A1@exesolutions.com>
From: Daniel Morgan <dmorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: size of user
References: <adksuk$dc0$1@cvs-server.gef.de> <ufviru3ttsvkaf@corp.supernews.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
Date: Thu, 06 Jun 2002 21:17:48 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1023398268 156.74.250.7 (Thu, 06 Jun 2002 15:17:48 MDT)
NNTP-Posting-Date: Thu, 06 Jun 2002 15:17:48 MDT
Organization: City of Seattle NewsReader Service
Xref: easynews comp.databases.oracle.misc:82600
X-Received-Date: Thu, 06 Jun 2002 14:15:13 MST (news.easynews.com)

Sybrand Bakker wrote:

> "Uwe Wagner" <Uwe.Wagner@gef.de> wrote in message
> news:adksuk$dc0$1@cvs-server.gef.de...
> > Hi,
> >
> > I want to know the bytes used by all tables from one user.
> > Is this information available from a table or view ?
> >
> > uwe
> >
> >
>
> select sum(bytes) from user_segments where segment_type = 'TABLE'
> or
> select sum(bytes) from dba_tables where owner = '<yourowner>' and
> segment_type = 'TABLE'
> etc.
>
> Hth

I assumed he also wanted associated indexes, etc. but you are
technically more correct given what he asked.

Daniel Morgan