select table_name, partition_name
from user_tab_partitions
where table_name='TAB_PART_COMPOSITE_INTERVAL';
| TABLE_NAME | PARTITION_NAME |
| TAB_PART_COMPOSITE_INTERVAL | TAB_PART_COMPOSITE_INTERVAL_P1 |
| TAB_PART_COMPOSITE_INTERVAL | SYS_P14036 |
select * from TAB_PART_COMPOSITE_INTERVAL partition(SYS_P14036);
select table_name, partition_name, subpartition_name
from user_tab_subpartitions
where table_name='TAB_PART_COMPOSITE_INTERVAL'
and partition_name='SYS_P14036';
| TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME |
| TAB_PART_COMPOSITE_INTERVAL | SYS_P14036 | SYS_SUBP14005 |
| TAB_PART_COMPOSITE_INTERVAL | SYS_P14036 | SYS_SUBP14006 |
select * from TAB_PART_COMPOSITE_INTERVAL subpartition(SYS_SUBP14028);
درباره این سایت