Re: Size of object in tablespace

<leo_at_tech-trans.com> wrote in message
news:1124148678.940359.141070_at_z14g2000cwz.googlegroups.com...
> Hi!
>
> How to define the size of object in tablespaces? For example, the
> size of user occupies in tablespace.
>
> Kai Ming
>

You mean something like:

break on owner
select owner, tablespace_name, sum(bytes) as bytes from dba_segments
group by owner, tablespace_name;

?

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup