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 -> Re: [Q] how to find how many row in each table in database?

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

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: 1997/07/29
Message-ID: <33DE2D81.416E@bms.com>#1/1

Larry Leung (llarry_at_hkstar.com) wrote:
> : 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
> Larry,

If you already do full exports regularly, you could look at the row counts from the export log files (assuming it's saved somewhere).



Joe Kazimierczyk
kazimiej_at_bms.com Received on Tue Jul 29 1997 - 00:00:00 CDT

Original text of this message

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