Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A query to return row counts of all tables in cat
If you collect the statistics, this may help...
select owner,table_name,num_rows from dba_tables where owner='XYZ' order by table_name; Received on Thu Nov 30 2006 - 15:43:16 CST