Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] how to find how many row in each table in database?
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).