column table_name          format a30
column partition_name      format a30
column high_value          format a30

drop table foxterrier purge;

Таблица удалена.


create table foxterrier
(yearnum number
)
partition by range(yearnum) interval (1)
(partition foxterrier#201801 values less than (201801)
);

Таблица создана.


insert into foxterrier(yearnum)
select 201801 + level - 1
from dual connect by level <= 12;

12 строк создано.


insert into foxterrier(yearnum)
select 201901 + level - 1
from dual connect by level <= 12;

12 строк создано.


commit;

Фиксация обновлений завершена.


select *
from foxterrier
order by yearnum;

   YEARNUM
----------
    201801
    201802
    201803
    201804
    201805
    201806
    201807
    201808
    201809
    201810
    201811
    201812
    201901
    201902
    201903
    201904
    201905
    201906
    201907
    201908
    201909
    201910
    201911
    201912

24 строк выбрано.


select table_name, partition_name, high_value, partition_position
from user_tab_partitions
where table_name = 'FOXTERRIER'
order by partition_position;

TABLE_NAME                     PARTITION_NAME                 HIGH_VALUE                     PARTITION_POSITION
------------------------------ ------------------------------ ------------------------------ ------------------
FOXTERRIER                     FOXTERRIER#201801              201801                                       1
FOXTERRIER                     SYS_P21432                     201802                                       2
FOXTERRIER                     SYS_P21433                     201803                                       3
FOXTERRIER                     SYS_P21434                     201804                                       4
FOXTERRIER                     SYS_P21435                     201805                                       5
FOXTERRIER                     SYS_P21436                     201806                                       6
FOXTERRIER                     SYS_P21437                     201807                                       7
FOXTERRIER                     SYS_P21438                     201808                                       8
FOXTERRIER                     SYS_P21439                     201809                                       9
FOXTERRIER                     SYS_P21440                     201810                                      10
FOXTERRIER                     SYS_P21441                     201811                                      11
FOXTERRIER                     SYS_P21442                     201812                                      12
FOXTERRIER                     SYS_P21443                     201813                                      13
FOXTERRIER                     SYS_P21444                     201902                                      14
FOXTERRIER                     SYS_P21445                     201903                                      15
FOXTERRIER                     SYS_P21446                     201904                                      16
FOXTERRIER                     SYS_P21447                     201905                                      17
FOXTERRIER                     SYS_P21448                     201906                                      18
FOXTERRIER                     SYS_P21449                     201907                                      19
FOXTERRIER                     SYS_P21450                     201908                                      20
FOXTERRIER                     SYS_P21451                     201909                                      21
FOXTERRIER                     SYS_P21452                     201910                                      22
FOXTERRIER                     SYS_P21453                     201911                                      23
FOXTERRIER                     SYS_P21454                     201912                                      24
FOXTERRIER                     SYS_P21455                     201913                                      25

25 строк выбрано.