[QUOTE][i]Originally posted by Oracledba8 [/i]
[B]Hi Please Issue this
exec dbms_utility.analyze_schema('yourschemaname','compute');
Then
Select count(*) from dba_tables
where row_num = 0;
Thanks..
[/B][/QUOTE]
Opps, it should be num_rows.
Take care
|
Results 1 to 6 of 6
Thread: TABLE COUNTThreaded View
|
Click Here to Expand Forum to Full Width |