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

?

CREATE INDEX INX_TEST_COMP1 ON TEST(ID,LRRQ)TABLESPACE TEST_IDXNOLOGGING   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的错误提示了，哦~~~~

?