11G R2 When partitioning key is Null value in interval Partitioned Table
Greetings All,Commonly, I use the below script to build a common partitioning, in this way, when the partitioning key is Null, the row will always preserve in MAXVALUE partition.
CREATE TABLE intervalpart (c1 NUMBER, c3 DATE)
PARTITION BY RANGE (c3)
(PARTITION part1
VALUES LESS THAN (TO_DATE ('01/12/2010', 'MM/DD/YYYY')),
PARTITION part2
VALUES LESS THAN (TO_DATE ('02/12/2010', 'MM/DD/YYYY'))
PARTITION part3
VALUES LESS THAN (MAXVALUE)
)
My question is when the partitioning key is null, database will store the row to which partition in an Interval Partitioned Table.
Interval Partitioned Table
CREATE TABLE intervalpart (c1 NUMBER, c3 DATE)
CREATE TABLE intervalpart (c1 NUMBER, c3 DATE)
PARTITION BY RANGE (c3)
(PARTITION part1
VALUES LESS THAN (TO_DATE ('01/12/2010', 'MM/DD/YYYY')),
PARTITION part2
VALUES LESS THAN (TO_DATE ('02/12/2010', 'MM/DD/YYYY'))
PARTITION part3
VALUES LESS THAN (MAXVALUE)
)
My question is when the partitioning key is null, database will store the row to which partition in an Interval Partitioned Table.
Interval Partitioned Table
CREATE TABLE intervalpart (c1 NUMBER, c3 DATE)
0