Count on all the tables under sapsr3

[Former Member]

Hello Experts ,

I need to find out the number of records in each table under the sapsr3 schema - could anyone please help me here ?? We are running Oracle 10.0.5.

Thanks

Dev

[former_member182967 · Accepted solution]

Hello Devpriy,

You can use the following SQL to get your approximate value (the result is depending on the DB statistics, it is not the real time data)

SQL> select TABLE_NAME, NUM_ROWS from DBA_TABLES where OWNER='SAPSR3'

Regards,

Ning Tong

[Former Member · Accepted solution]

Thanks a lot.

[former_member185954 · Accepted solution]

I would include the count clause to count tables, but anyways you got the idea