oracle自动建立分区interval,Oracle 11g创建Interval分区表

TABLE_NAME  PARTITION_NAME  HIGH_VALUE                                                                       PARTITION_POSITION

------------------------------------------------------------------------------------------------------------ ------------------- --

INT_PAR     SYS_P50         TO_DATE(' 2010-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                  11

INT_PAR     SYS_P49         TO_DATE(' 2009-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                  10

INT_PAR     SYS_P48         TO_DATE(' 2008-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   9

INT_PAR     SYS_P47         TO_DATE(' 2007-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   8

INT_PAR     SYS_P46         TO_DATE(' 2006-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   7

INT_PAR     SYS_P45         TO_DATE(' 2005-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   6

INT_PAR     SYS_P44         TO_DATE(' 2004-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   5

INT_PAR     SYS_P43         TO_DATE(' 2003-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   4

INT_PAR     SYS_P42         TO_DATE(' 2002-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   3

INT_PAR     SYS_P41         TO_DATE(' 2001-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   2

INT_PAR     INTE_PAR1       TO_DATE(' 2000-09-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA                   16.

SQL> SELECT * FROM hr.int_par partition(sys_p46);

ID JOIN_DATE

---------- -----------

6 2006-1-5

SQL> SELECT * FROM hr.int_par partition(sys_p50);

ID JOIN_DATE

---------- -----------

10 2010-1-8