分割槽表學習之三

-----------建立list分割槽
create table t_partition_list ( 
  BAZ001 NUMBER(16),
  BAZ002 NUMBER(16),
  AAB001 NUMBER(16) not null,
  AAC001 NUMBER(16) not null,
  AAE140 VARCHAR2(3) not null,
  AAC030 DATE not NULL,
  AAC008 VARCHAR2(3) not null,
  AAC049 DATE,
  AAE200 NUMBER(3),
  AAB034 VARCHAR2(16) not null,
  AAA027 VARCHAR2(6),
  BAZ003 NUMBER(16),
  BAZ004 VARCHAR2(1))
partition by list(aae140)(
partition t_list_p1 values ('11','12','21'),
partition t_list_p2 values ('31','32'),
partition t_list_p3 values ('33','35','38','3b','3d') ,
partition t_list_pd values (DEFAULT));
---------插入資料
INSERT /*+ append */ INTO t_partition_list SELECT * FROM ac02;
---------查詢分割槽表
SELECT * FROM t_partition_list partition(t_list_p1);
---------修改list分割槽表
alter table t_partition_list modify partition t_list_p1 add values ('31');
---------刪除指定分割槽的value值
alter table t_partition_list modify partition t_list_p3 drop values ('3b');
---------移動表分割槽
alter table t_partition_list move partition t_list_p3 tablespace test;
---------重新命名錶分割槽
alter table t_partition_list rename partition t_list_p4 to t_list_p3;
---------查詢分割槽資訊
SELECT * FROM User_Tab_Partitions;
SELECT * FROM User_Part_Tables;
SELECT * FROM User_Segments;-------分割槽段大小可以從此檢視查詢