thank you.
--- "Dennis M. Heisler" <[EMAIL PROTECTED]>
wrote:
> Analyze the tables, then look at num_rows in
> dba_tables.
>
>
> Andrea Oracle wrote:
>
> > All,
> >
> > Is there an easy way to find out how many rows are
> > there is each table for a schema? Thank you.
> >
> > Andrea
> >
> > _
The most accurate way would be to do
select count(*) from table
but that might be slow if your table is ~100GB in size. You can
still make a query to USER_TABLES or DBA_TABLES and there is a column
called NUM_ROWS which tels you how many rows did the table have when it
was last analyzed.
-Or
Hi,
Analyze all the tables and select num_rows from dba_tables. Hope this helps
you.
Uday
-Original Message-
Oracle
Sent: Wednesday, April 18, 2001 9:31 PM
To: Multiple recipients of list ORACLE-L
All,
Is there an easy way to find out how many rows are
there is each table for a schema?
Run the following script:
-
Aim : TIP for "find out the no. of rows in each tables in user's
schema"
--Date: 19th May, 2000
--Author: Ramesh Papnoi
--Subject : TIP for finding out the no. of rows in each tables
in User's Schema on which user
Or if your tables are all analyzed and you want a rough answer (faster but
less accurate)
select table_name , num_rows from dba_tables where owner='&schema';
You might want to round the num_rows.
Again, only as good as the last analyze - when it was done and estimate vs
compute.
Regards,
Bruce
Analyze the tables, then look at num_rows in dba_tables.
Andrea Oracle wrote:
> All,
>
> Is there an easy way to find out how many rows are
> there is each table for a schema? Thank you.
>
> Andrea
>
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy
set heading stuff off
spool tblcount.sql
select
'select count(*) from ' || tablename || ' ;'
from
data_dictionary_table
where
schema = 'the one you want';
spool off
@tblcount.sql
On 18 Apr 2001, at 17:30, Andrea Oracle wrote:
> Is there an easy way to find out ho
All,
Is there an easy way to find out how many rows are
there is each table for a schema? Thank you.
Andrea
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-