分区表及分区索引(4)--创建list分区

SQL> create table t_part_list (id number(10),name varchar2(10))
  2  partition by list (id)(
  3  partition t_list_p1 values (1)tablespace part01,
  4  partition t_list_p2 values (2) tablespace part02,
  5  partition t_list_p3 values (3) tablespace part03);
 
Table created








SQL> insert into t_part_list values (1,'asdfad');
 
1 row inserted
 
SQL> insert into t_part_list values (2,'asfda');
 
1 row inserted


 
SQL> insert into t_part_list values (3,'3333');
 
1 row inserted


SQL> insert into t_part_list values (3,'afasdf');
 
1 row inserted
 
SQL> commit;
 
Commit complete
 
SQL> select * from t_part_list partition(t_list_p3);
 
         ID NAME
----------- ----------
          3 3333

          3 afasdf

分区表及分区索引(1)--前言                                                                                      
分区表及分区索引(2)--创建range分区                                                        
分区表及分区索引(3)--创建hash分区                                                          
分区表及分区索引(4)--创建list分区                                                                             
分区表及分区索引(5)--创建range-hash组合分区                         
分区表及分区索引(6)--创建range-list组合分区                            
分区表及分区索引(7)                                                                                                
分区表及分区索引(8)--增加和收缩表分区                                                    
分区表及分区索引(9)--删除表分区                                                                              
分区表及分区索引(10)--交换分区                                                                               
分区表及分区索引(11)--合并表分区                                                                            
分区表及分区索引(12)--修改list表分区                                                       
分区表及分区索引(13)--分隔表分区                                                                            
分区表及分区索引(14)--截断、移动和重命名                                              
分区表及分区索引(15)--修改表分区属性和模板                           
分区表及分区索引(16)--增加和删除索引分区                                              
分区表及分区索引(17)--其它索引分区管理操作                           
分区表及分区索引(18)--结束语