| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL to find out user table which count > 0!
If you have time I would do this:
exec dbms_utility.analyze_schema('SCHEMA','COMPUTE');
then just select the num_rows from dba_tables. You have to do the
compute first though. We run a cron job to do the computes daily in the
evening or early morning so they are relatively up to date.
Hope this helps,
Glen
Reid Lai wrote:
>
> Man,
>
> Try num_rows column from dba_tables system view.
>
> Yeung Man wrote:
>
> > Hi,
> >
> > I want to find out all user tables in our application system with
> > rowcount > 0. I know I can do with the analysis and the query the dict. But,
> > can I just use SQL to find them out? TIA.
> >
> > Best Regards,
> > Man
> >
> > yngm_at_chowsangsang.com
>
> --
> Best Regards,
>
> Reid Lai <reidlai_at_hk.super.net>
> Oracle 7.3 Certified Database Administrator (OCP)
> ================================================
> The above opinions are mine and do not represent
> any official standpoints of my employer
--
<html>
<font face="Tahoma"
size=1>|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-|<br>
Glen
Upreti<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>
<br>
Oracle
DBA<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>
<br>
Northern Arizona University<br>
Phone: (520)523-8393
<x-tab> </x-tab>Fax:(520)523-7407<br>
Glen.Upreti_at_nau.edu<br>
</font></html>
Received on Fri Jan 15 1999 - 11:28:12 CST
 |
 |