参考:
CREATE INDEX PL_A_NDX ON A(F_RQ)
local
(
partition a200301 tablespace a200301,
partition a200302 tablespace a200302,
partition a200303 tablespace a200303,
partition a200304 tablespace a200304,
partition a200305 tablespace a200305,
partition a200306 tablespace a200306,
partition a200307 tablespace a200307,
partition a200308 tablespace a200308,
partition a200309 tablespace a200309,
partition a200310 tablespace a200310,
partition a200311 tablespace a200311,
partition a200312 tablespace a200312,
partition a200401 tablespace a200401,
partition a200402 tablespace a200402,
partition a200403 tablespace a200403,
partition a200404 tablespace a200404,
partition a200405 tablespace a200405,
partition a200406 tablespace a200406,
partition a200407 tablespace a200407,
partition a200408 tablespace a200408,
partition a200409 tablespace a200409,
partition a200410 tablespace a200410,
partition a200411 tablespace a200411,
partition a200412 tablespace a200412,
partition a200501 tablespace a200501,
partition a200502 tablespace a200502,
partition a200503 tablespace a200503,
partition a200504 tablespace a200504,
partition a200505 tablespace a200505,
partition a200506 tablespace a200506,
partition a200507 tablespace a200507,
partition a200508 tablespace a200508,
partition a200509 tablespace a200509,
partition a200510 tablespace a200510,
partition a200511 tablespace a200511,
partition amax tablespace amax
)