This shows you the differences between two versions of the page.
— |
kurs:created_partioned_table [2021/04/13 10:42] (current) admin created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | CREATE TABLE A | ||
+ | ( | ||
+ | a NUMBER, | ||
+ | CreationDate DATE | ||
+ | ) | ||
+ | PARTITION BY RANGE (CreationDate) | ||
+ | INTERVAL ( NUMTODSINTERVAL (1, 'DAY') ) | ||
+ | (PARTITION P_FIRST | ||
+ | VALUES LESS THAN (TIMESTAMP ' 2001-01-01 00:00:00')) |