可以查系统视图，例如
--查询所有分区表及子表
select table_owner,table_name,partition_name,high_value from DBA_TAB_PARTITIONS;

--查询分区表不包含2025-01关键字的
SELECT A.,B. FROM (
SELECT DISTINCT TABLE_OWNER,TABLE_NAME FROM DBA_TAB_PARTITIONS
) A LEFT JOIN
(SELECT DISTINCT TABLE_OWNER AS OW,TABLE_NAME AS TAB FROM DBA_TAB_PARTITIONS
WHERE HIGH_VALUE LIKE '%2025-01%' ) B ON A.TABLE_OWNER=B.OW AND A.TABLE_NAME=B.TAB
用自己做做关联，其中B.OW B.TAB为空的，就是没有创建2025-01关键字分区的表