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
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
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.
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
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
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 the
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