Oracle查看用户表分区情况

oracle查看用户表分区情况

SELECT
    table_name,
    partitioning_key,
    num_partitions
FROM
    user_tab_partitions
WHERE
    table_name IN (SELECT table_name FROM user_tables WHERE partitioned = 'YES');

查看当前用户分区的表

SELECT table_name FROM user_tables WHERE partitioned = 'YES';

查看所有用户分区的表

SELECT table_name FROM dba_tables WHERE partitioned = 'YES';