select زدن از یک partition یا subpartition خاص در یک جدول بر اساس نام

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);