12C\u5f00\u59cb\u53ef\u4ee5\u5728\u540c\u4e00\u5b57\u6bb5\u4e0a\u521b\u5efa\u4e0d\u540c\u79cd\u7c7b\u7684\u7d22\u5f15\uff0c\u524d\u63d0\u6761\u4ef6\u662f\u53ea\u80fd\u542f\u7528\u4e00\u4e2a\u3002\u5efa\u7b2c\u4e8c\u4e2a\u7d22\u5f15\u65f6\uff0c\u9700\u8981\u628a\u7b2c\u4e00\u4e2a\u7d22\u5f15invisible\u3002<\/p>\n
SQL> CREATE TABLE t_whs (ID number, WNAME varchar2(10));\n\nTable created.\n\nSQL> begin\n 2 for i in 0 .. 49 loop\n 3 insert into t_whs values(i,'whs');\n 4 end loop ;\n 5 commit;\n 6 end;\n 7 \/\n\nPL\/SQL procedure successfully completed.\n\nSQL> create index idx_id1 on t_whs(id);\n\nIndex created.\n\nSQL> create bitmap index idx_id1 on t_whs(id);\ncreate bitmap index idx_id1 on t_whs(id)\n *\nERROR at line 1:\nORA-00955: name is already used by an existing object\n\nSQL> create bitmap index idx_id2 on t_whs(id);\ncreate bitmap index idx_id2 on t_whs(id)\n *\nERROR at line 1:\nORA-01408: such column list already indexed\n\nSQL> alter index idx_id1 invisible; \u300a==\u9700\u8981invisible\u540e\u624d\u884c\n\nIndex altered.\n\nSQL> create bitmap index idx_id2 on t_whs(id);\n\nIndex created.<\/code><\/pre>\n\u4ee5\u4e0b\u4e3a11.2.0.4\u4e0a\u7684\u64cd\u4f5c\uff0c\u662f\u4e0d\u652f\u6301\u7684<\/p>\n
[oracle@hammer ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 3 11:00:32 2020\n\nCopyright (c) 1982, 2013, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\n\nSQL> CREATE TABLE t_whs (ID number, WNAME varchar2(10));\n\nTable created.\n\nSQL> begin\n 2 for i in 0 .. 49 loop\n 3 insert into t_whs values(i,'whs');\n 4 end loop ;\n 5 commit;\n 6 end;\n 7 \/\n\nPL\/SQL procedure successfully completed.\n\nSQL> create index idx_id1 on t_whs(id);\n\nIndex created.\n\nSQL> create bitmap index idx_id2 on t_whs(id);\ncreate bitmap index idx_id2 on t_whs(id)\n *\nERROR at line 1:\nORA-01408: such column list already indexed\n\nSQL> alter index idx_id1 invisible;\n\nIndex altered.\n\nSQL> create bitmap index idx_id2 on t_whs(id);\ncreate bitmap index idx_id2 on t_whs(id)\n *\nERROR at line 1:\nORA-01408: such column list already indexed<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"12C\u5f00\u59cb\u53ef\u4ee5\u5728\u540c\u4e00\u5b57\u6bb5\u4e0a\u521b\u5efa\u4e0d\u540c\u79cd\u7c7b\u7684\u7d22\u5f15\uff0c\u524d\u63d0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,39],"tags":[],"class_list":["post-482","post","type-post","status-publish","format-standard","hentry","category-oracle-12c","category-39"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=482"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/482\/revisions"}],"predecessor-version":[{"id":483,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/482\/revisions\/483"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=482"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}