普通表转为分区表（二）-insert

create table tt as select * from dba_objects order by object_id;
创建一个示例表。
1)插入
1.首先找到分区的字段（desc tt）
SQL> select max(object_id) from tt;


MAX(OBJECT_ID)
--------------
         87390


1 row selected.


create table ttvv  partition by range (object_id)
   (partition p1 values less than (1000),
      partition p2 values less than (30000),
      partition p3 values less than (50000),
      partition p4 values less than (maxvalue))
      as select * from tt;
 


SQL> select count(*) from ttvv partition(p2);


  COUNT(*)
----------
     28661


1 row selected.
查询ttvv有几个分区
select partition_name from user_segments where segment_type='TABLE PARTITION' and segment_name='TTVV';




删除分区
ALTER TABLE ttvv DROP PARTITION p1;
清数据
ALTER TABLE ttvv TRUNCATE PARTITION p1;