Oracle中怎么做分区索引?

2025-03-23 05:55:16
推荐回答(1个)
回答1:

create index dinya_idx_t on dinya_test(item_id)
   global partition by range(item_id)
   (
   partition idx_1 values less than (1000) tablespace dinya_space01,
   partition idx_2 values less than (10000) tablespace dinya_space02,
   partition idx_3 values less than (maxvalue) tablespace dinya_space03
  );