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;
创建一个示例表。
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;