ORA-14038 global partitioned index must be prefixed 分区索引

 

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的错误提示了，哦~~~~