Database DataWarehousing (MOSC)

MOSC Banner

11G R2 When partitioning key is Null value in interval Partitioned Table

edited Mar 27, 2013 5:04AM in Database DataWarehousing (MOSC) 2 commentsAnswered ✓
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center