Re: size of user

Uwe Wagner wrote:

> 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)/1024/1024 MB_USED
FROM user_segments;

or

SELECT SUM(bytes)/1024/1024 MB_USED
FROM all_segments
WHERE owner = <owner_name>;

Daniel Morgan Received on Thu Jun 06 2002 - 15:27:56 CDT