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);
page revision: 0, last edited: 21 May 2009 09:51