Hello,
11G
SUN
Attempted to create table and partition daily (86400000) as the time is in number (utc), miliseconds:
CREATE TABLE "CLSINFO"
(
"ID" NUMBER(19,0) NOT NULL ENABLE,
"CLDRESS" VARCHAR2(18 CHAR) NOT NULL ENABLE,
"SESSTART" NUMBER(19,0) DEFAULT 0 NOT NULL ENABLE,
"SESEND" NUMBER(19,0) DEFAULT 64060617600000,
"SESTIME" NUMBER(19,0) DEFAULT 0,
PRIMARY KEY ("ID") USING INDEX TABLESPACE "BIG_INDEX" ENABLE,
CONSTRAINT "CLNFO_K" UNIQUE ("CLDRESS", "SESSTART") USING INDEX TABLESPACE "BIG_INDEX" ENABLE
)
PARTITION BY RANGE ("SESEND")
INTERVAL(86400000) STORE IN "BIG_DATA"
(PARTITION "P0" VALUES LESS THAN (946713600000))
TABLESPACE "BIG_DATA"
;
SQL Error: ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
Actually, w/o the partition close, the table is ok, something is fishy with the interval, I assume...
What I'm messing with here?
Thx,