Re: space used by a user in a tablespace

"Paul Drake" <drak0nian_at_yahoo.com> a écrit dans le message de news:1ac7c7b3.0311111624.62de4664_at_posting.google.com...
> "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

dba_ts_quotas contains data only for users with quotas, so users with "unlimited tablespace" privilege are not in this view (unless you give them some quotas which are not taken into account by Oracle).

Michel Cadot Received on Wed Nov 12 2003 - 00:45:43 CST