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