Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to check the number of partitions under each user in the database, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let's take a look at it.

-View the number of partitions under each user

SELECT T.TABLE_OWNER, COUNT (*)

FROM DBA_TAB_PARTITIONS T

WHERE LENGTH (PARTITION_NAME) = 12

AND PARTITION_NAME LIKE 'PART%'

AND PARTITION_NAME

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.