Oracle 建立分割槽表

 -----建立表空間
 create tablespace myTableSpace_1 datafile 'C:/oracle/product/10.1.0/oradata/mydata/myTableSpace1.dbf' 
 size 100m extent management local uniform size 256K
 
  create tablespace myTableSpace_2 datafile 'C:/oracle/product/10.1.0/oradata/mydata/myTableSpace2.dbf' 
 size 100m extent management local uniform size 256K
 
   create tablespace myTableSpace_3 datafile 'C:/oracle/product/10.1.0/oradata/mydata/myTableSpace3.dbf' 
 size 100m extent management local uniform size 256K
 
 
 -----建立分割槽
 create table MyTest
 (
        id number,
        name nvarchar2(100)
 )
 partition by range(id)
 (
  partition T1 values less than (100) tablespace myTableSpace_1,
  partition T2 values less than (1000) tablespace myTableSpace_2,
  partition T3 values less than (maxvalue) tablespace myTableSpace_3)


-----設定表可以修改
alter table mytest2 enable row movement;
  
  -----給分割槽表插入資料
  
  insert into MyTest values (10,'f1111');
  insert into MyTest values (20,'f1112');
  insert into MyTest values (100,'f1112');
  insert into MyTest values (200,'f1112');
  insert into MyTest values (1001,'f1112');
  commit;
  
 ------查詢分割槽表 
  select * from MyTest
 
  select * from myTest partition(T1);
  select * from myTest partition(T2);
  select * from myTest partition(T3);
  
  ------?刪除一個有表分割槽，同時些表分割槽的資料也將刪除
  ALTER TABLE myTest DROP PARTITION T3; 
  ------  插入一個表分割槽，插入時必須是在最大的表分割槽住下插入
  alter table myTest add partition T3 values less than (10000) tablespace myTableSpace_3;