11.2.0.3
just trying to learn the syntax. I have not worked with IOTs and I am exploring a feature I have not really used to try to learn something new.
I know about intervals. However, I am stumped as to why this doesn't work and I just want to figure out what I am doing wrong.
This exact split syntax below, works on a heap table without errors.
When I run the following split against a regular heap table it works.
CREATE TABLE MYTABLE (
INSERT_DATE date,
myfield1 varchar2(50),
myfield2 varchar2(50),
myfield3 varchar2(50),
myfield4 varchar2(50),
CONSTRAINT pk_my_pk
PRIMARY KEY (insert_date,myfield1,myfield2,myfield3,myfield4))
ORGANIZATION INDEX
partition by range (insert_date)
( partition B4_2013_01_01_01 values less than (to_date('2013-01-01-01','YYYY-MM-DD-HH24')),
partition FUTURE values less than (MAXVALUE))
alter table MYTABLE split partition "FUTURE" at ( to_date('09_MAY_2013_13','DD_MON_YYYY_HH24' ) ) into ( partition "B4_09_MAY_2013_13", partition "FUTURE" ) update global indexes
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected BINARY got NUMBER
Edited by: Guess2 on May 14, 2013 8:45 AM