Re: count for a newbie

What is the count referring to?
The number of extents?
The number of records?
Which Oracle version are you using?
(The answer will be different dependent on version, and it is too much work to provide two completely different solutions)

Regards,

Sybrand Bakker, Oracle DBA

"Bryant Baecht" <b_b_a_e_c_h_t_at_sun_flower.com> wrote in message news:sscevccjh3t113_at_corp.supernews.com...
> Hi all,
> I want to select all segments from sys.dba_segments by a userid and
 do a
> count on each table. My SQL looks something like this but it doesn't
 work.
>
> select segment_name,count(*) from sys.dba_segments where user='tom' group
 by
> segment_name;
>
> What I want my output to look like is this:
>
> SEGMENT_NAME COUNT(*)
> ----------------------------------------------
>
> doctaba 349
> user_table1 102434
> user_table2 3096
>
> ..
>
> Any quick pointers are definitely appreciated.
>
> TIA,
>
> Bryant
>
>
>
Received on Mon Sep 18 2000 - 12:24:12 CDT