I need to export the records of some tables of the same schema in oracle , but due to limitations in the machine from which I am going to carry out this process, I need to know the number of rows of the tables of said schema to decide if I do it this way or I use another alternative to copy the records between one environment and another.
How can I quickly and effectively determine the number of records of all tables in the schema?
The easiest way to achieve it, that is, without procedures or complex things, is to execute the following query:
The column
num_rows
contains the number of rows or records in each of the tables.Update:
As @jpertejo highlights:
Hence, the query includes the column
last_analyzed
whose purpose is to report the date on which the most recent statistical analysis was made for each table.