Difference between user_segments and dba_segments

[gandolf989]

Ok Agreed thanks.But now can u pls tell me how I can know current schema name if i am using user_segments;
ie
select sum(bytes) from user_segments wher segment_type='TABLE';

Here how can I find schema name.

Thanks,
Sam

user will return the current schema user. For example "select user, sum(bytes) from user_segments where segment_type='TABLE';"