Please help me to clear the defination of below partition syntex.
PARTITION BY CASE_N(
EDW_END_TS = TIMESTAMP '9999-12-31 23:59:59.999999+10:00',
NO CASE OR UNKNOWN);
when i check dbc,indexconstrain table constarin column is as below
CHECK ((CASE_N(EDW_END_TS = TIMESTAMP '9999-12-31 23:59:59.999999+10:00', NO CASE OR UNKNOWN)) BETWEEN 1 AND 00002)
are we creating single partition ?? what is mean by +10 and between 1 and 00002.
The +10 is the Time Zone
You are defining two partitions, the equal to literal timestamp and all others distinct to the literal.