Manage Partition Index

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/partiti.htm#sthref2628

CREATE INDEX loc_dept_ix ON dept(deptno) LOCAL;

CREATE INDEX hgidx ON tab (c1,c2,c3) GLOBAL
     PARTITION BY HASH (c1,c2)
     (PARTITION p1  TABLESPACE tbs_1,
      PARTITION p2  TABLESPACE tbs_2,
      PARTITION p3  TABLESPACE tbs_3,
      PARTITION p4  TABLESPACE tbs_4);
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License