You can do it the hard way and loop trough and count all the tables, or you can query the user_tables table.
select table_name, num_rows from user_tables where tablespace_name = 'ARSYSTEM' Regards, Jarl On Feb 19, 2008 11:29 AM, Toby White <[EMAIL PROTECTED]> wrote: > ** > > Hi > > Does anyone know how I can count the number of records in each form on an > Oracle database. I searched the list and found the way to do it using SQL > Server but stuck on getting the solution for Oracle. > > Thanks > Toby __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"