Orale分区目录

Orale分区索引
?

1. --1、建分区表??CREATE?TABLE?P_TAB(??
2. C1?INT,??C2?VARCHAR2(16),??
3. C3?VARCHAR2(64),??C4?INT?,??
4. CONSTRAINT?PK_PT?PRIMARY?KEY?(C1)??)??
5. PARTITION?BY?RANGE(C1)(??PARTITION?P1?VALUES?LESS?THAN?(10000000),??
6. PARTITION?P2?VALUES?LESS?THAN?(20000000),??PARTITION?P3?VALUES?LESS?THAN?(30000000),??
7. PARTITION?P4?VALUES?LESS?THAN?(MAXVALUE)??);??
8. --2、建全局分区索引??CREATE?INDEX?IDX_PT_C4?ON?P_TAB(C4)?GLOBAL?PARTITION?BY?RANGE(C4)??
9. (??PARTITION?IP1?VALUES?LESS?THAN(10000),??
10. PARTITION?IP2?VALUES?LESS?THAN(20000),??PARTITION?IP3?VALUES?LESS?THAN(MAXVALUE)??
11. );??--3、建本地分区索引??
12. CREATE?INDEX?IDX_PT_C2?ON?P_TAB(C2)?LOCAL?(PARTITION?P1,PARTITION?P2,PARTITION?P3,PARTITION?P4);??--4、建全局分区索引(与分区表分区规则相同的列上)??
13. CREATE?INDEX?IDX_PT_C1??ON?P_TAB(C1)??
14. GLOBAL?PARTITION?BY?RANGE?(C1)??(??
15. PARTITION?IP01?VALUES?LESS?THAN?(10000000),??PARTITION?IP02?VALUES?LESS?THAN?(20000000),??
16. PARTITION?IP03?VALUES?LESS?THAN?(30000000),??PARTITION?IP04?VALUES?LESS?THAN?(MAXVALUE)??
17. );??--5、分区索引数据字典查看??
18. SELECT?*?FROM?USER_IND_PARTITIONS;??SELECT?*?FROM?USER_PART_INDEXES;?