CREATE INDEX INX_TEST_COMP1 ON TEST(ID,LRRQ)
TABLESPACE TEST_IDX
NOLOGGING
GLOBAL PARTITION BY RANGE (LRRQ)
(
PARTITION IDX_TEST_LRRQ_201201 VALUES LESS THAN (TO_DATE('20120201','YYYYMMDD')),
PARTITION IDX_TEST_LRRQ_201202 VALUES LESS THAN (TO_DATE('20120301','YYYYMMDD')),
PARTITION IDX_TEST_LRRQ_OHTER VALUES LESS THAN (MAXVALUE)
);
在PL/SQL DEVELOPER中执行报错
ORA-14038 global partitioned index must be prefixed
找了小半个小时,终于发现错误的原因
改成 CREATE INDEX INX_TEST_COMP1 ON TEST(LRRQ,ID)就好了,好吧,我服了ORALCE的错误提示了,哦~~~~