How can we check the number of records in each partition using Oracle?

You can use the following SQL statement to check the number of records in each partition:

SELECT table_name,
       partition_name,
       num_rows
FROM all_tab_partitions
WHERE table_name = 'your_table_name';

In this case, your_table_name is the name of the table you want to view. This statement will show the table name, partition name, and number of data entries for each partition.

广告
Closing in 10 seconds
bannerAds