一个字段只能建立一个同一顺序的单列索引
SQL> desc test20170824
Name Null? Type
----------------------------------------- -------- ----------------------------
SALES_ID NUMBER
CUST_ID NOT NULL NUMBER
SALES_AMT NUMBER
SQL> create index ind_1 on test20170824(SALES_ID);
Index created.
SQL> create index ind_2 on test20170824(SALES_ID);
create index ind_2 on test20170824(SALES_ID)
*
ERROR at line 1:
ORA-01408: such column list already indexed
SQL> create index ind_2 on test20170824(SALES_ID desc);
Index created.
SQL> create index ind_22 on test20170824(SALES_ID,CUST_ID);
Index created.
SQL> create index ind_23 on test20170824(SALES_ID,CUST_ID);
create index ind_23 on test20170824(SALES_ID,CUST_ID)
*
ERROR at line 1:
ORA-01408: such column list already indexed
SQL> create index ind_23 on test20170824(CUST_ID,SALES_ID);
Index created.
Name Null? Type
----------------------------------------- -------- ----------------------------
SALES_ID NUMBER
CUST_ID NOT NULL NUMBER
SALES_AMT NUMBER
SQL> create index ind_1 on test20170824(SALES_ID);
Index created.
SQL> create index ind_2 on test20170824(SALES_ID);
create index ind_2 on test20170824(SALES_ID)
*
ERROR at line 1:
ORA-01408: such column list already indexed
SQL> create index ind_2 on test20170824(SALES_ID desc);
Index created.
SQL> create index ind_22 on test20170824(SALES_ID,CUST_ID);
Index created.
SQL> create index ind_23 on test20170824(SALES_ID,CUST_ID);
create index ind_23 on test20170824(SALES_ID,CUST_ID)
*
ERROR at line 1:
ORA-01408: such column list already indexed
SQL> create index ind_23 on test20170824(CUST_ID,SALES_ID);
Index created.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30126024/viewspace-2144046/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
OCR的恢复，使用物理备份
下一篇：
RAC改VIP和SCAN IP
请登录后发表评论
登录
全部评论
