Oracle About Partitioning

--Delete Partition
ALTER TABLE tt_trms_all_air_task DROP PARTITION tt_trms_all_air_task_p20171030;

1. Add a partition
ALTER TABLE Tt_trms_all_air_task
ADD PARTITION tt_trms_all_air_task_p20171031 VALUES less THAN (TIMESTAMP ' 2017-10-31 00:00:00 ');
ALTER TABLE Tt_trms_all_air_task
ADD PARTITION tt_trms_all_air_task_p20171106 VALUES less THAN (TIMESTAMP ' 2017-11-07 00:00:00 ');

--Modify Partition field time

Check the production row movement strategy select Table_name,owner,row_movement from dba_tables WHERE table_name = ' table_name '; It's a disabled state, really.

1. Modify the policy ALTER TABLE schema.table_name enable row movement;
2. Execute the statement
3. Change back ALTER TABLE schema.table_name disable row movement;

Oracle About Partitioning