How to create and operate a partitioned table

Create a partition:/***** create a partition table *****/create table sales (dopetno number, shopid varchar2 (20), shopname varchar2 (20), tdate date) partition by range (tdate) (partition p_2007_min values less than (to_date ('00:00:00 ', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2008 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2009 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2010 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2011 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2012 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2013 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '), partition p_2014_max values less than (maxvalue);/*** single-query Partition Table **/select * from sales partition (p_2007_min ); select * from sales partition (p_2008); select * from sales partition (p_2009); select * from sales partition (p_2010); select * from sales partition (p_2011 ); select * from sales partition (p_2012); select * from sales partition (p_2013); select * from sales partition (p_2014); select * from sales partition (p_2015 ); select * from sales partition (p_2016_max); delete a partition: /***** extended partition table *****/-- Create Table sales_tmp as select * from sales where 1 = 2; -- put the last partition data, insert into sales_tmp select * from sales partition (p_2014_max); -- Delete the last partition alter table sales drop partition p_2014_max; -- new partition 1 alter table sales add partition p_2014 values less than (to_date ('00:00:00 ', 'syyyy-MM-DD hh24: MI: ss ', 'nls _ calendar = Gregorian '); -- new partition 2 alter table sales add partition p_2015 values less than (to_date ('00:00:00', 'syyyy-MM-DD hh24: mi: ss', 'nls _ calendar = Gregorian '); -- adds a new partition 3 alter table sales add partition p_2016_max values less than (maxvalue ); -- Insert the data in the temporary table to the new table insert into sales select * From sales_tmpdrop table sales_tmp;/** the end **/other operations: select * from sales where to_char (tdate, 'yyyy')> = '000000' and to_char (tdate, 'yyyy') <= '000000' Delete from sales where to_char (tdate, 'yyyy')> = '000000' is similar to other common table operations. there is no big difference. note. partition tables are divided into several types. The preceding operations are range partitions. other operations have different rules.