不算MAX分区哦
--查询最大分区
SELECT table_owner,
table_name,
partition_name,
substr(partition_name, instr(partition_name, '_', -1)+1),
PARTITION_NAME
FROM (select table_owner,
table_name,+
PARTITION_NAME,
RANK() OVER(partition by TABLE_OWNER, TABLE_NAME ORDER BY partition_position DESC) AA
from dba_tab_partitions
where table_owner not in ('DSG','SYSTEM','SYS')
)
WHERE AA = 2
order by 4
--查询最大分区
SELECT table_owner,
table_name,
partition_name,
substr(partition_name, instr(partition_name, '_', -1)+1),
PARTITION_NAME
FROM (select table_owner,
table_name,+
PARTITION_NAME,
RANK() OVER(partition by TABLE_OWNER, TABLE_NAME ORDER BY partition_position DESC) AA
from dba_tab_partitions
where table_owner not in ('DSG','SYSTEM','SYS')
)
WHERE AA = 2
order by 4
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/308563/viewspace-2136318/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/308563/viewspace-2136318/