Re: space used by a user in a tablespace

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:<tZasb.829$bT1.5034150_at_news-text.cableinet.net>...
> Hi,
>
> I need to find out the amount of space in actual MB, GB etc that a user is
> using. I know how to do this to determine the physical disk space a
> tablespace is taking up but is it possible to do the same but on a user by
> user level within a tablespace?
>
> This is on 8i and 9i on Solaris and Linux
>
> thanks

Tom,

the view dba_ts_quotas will show how much is allocated and used by each user for each tablespace on which they have a quota.

Pd Received on Tue Nov 11 2003 - 18:24:03 CST