43 lines
888 B
SQL
43 lines
888 B
SQL
/* Daily INTERVAL Partition Example */
|
|
|
|
create table tab_range_interval_partioned
|
|
(
|
|
col1 DATE NOT NULL
|
|
, col2 VARCHAR2(20)
|
|
)
|
|
partition by RANGE (col1) INTERVAL ( NUMTODSINTERVAL(1,'DAY') )
|
|
(
|
|
PARTITION part_01 values LESS THAN ( TO_DATE('01-SEP-2014','DD-MON-YYYY') )
|
|
);
|
|
|
|
|
|
alter table tab_range_interval_partioned
|
|
add constraint tab1_PK
|
|
primary key (col1) using index LOCAL
|
|
PCTFREE 0 TABLESPACE USERS ENABLE
|
|
;
|
|
|
|
create unique index tab1_PK on tab_range_interval_partioned(col1) LOCAL ;
|
|
|
|
alter table tab_range_interval_partioned
|
|
add constraint tab1_PK
|
|
primary key (col1) using index tab1_PK
|
|
ENABLE
|
|
;
|
|
|
|
|
|
|
|
create table tab_range_interval_partioned
|
|
(
|
|
col1 NUMBER NOT NULL
|
|
, col2 VARCHAR2(20)
|
|
)
|
|
partition by RANGE (col1 ) INTERVAL ( 1000 )
|
|
(
|
|
PARTITION part_01 values LESS THAN ( 1000 )
|
|
);
|
|
|
|
|
|
|
|
|