Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> [Q] how to find how many row in each table in database?

[Q] how to find how many row in each table in database?

From: Larry Leung <llarry_at_hkstar.com>
Date: 1997/07/29
Message-ID: <33DDEE18.5C465511@hkstar.com>#1/1

hello everyone,

i just wonder is there a better way to find out how many row of each table in
the database. It is because i am assigned a job to refresh our development
database from the production one.

by 'select count(*)' from each table seems time consuming.

thanks in advance

larry Received on Tue Jul 29 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US