Partition table maintenance
Background:
There is a large amount of useless data in the SEND_CONTROL_HIS1 partition table, which does not affect performance, but some partitions can be deleted to save storage space.
-- look up what objects are in the tablespace
Select owner,segment_name,segment_type,partition_name,bytes/1024/1024 As "occupies space M"
From dba_segments a where a.tablespaceful nameplate Portal data 'And segment_name='CONTROL_HIS1'
Order By bytes Desc
Implementation steps:
1. Delete the first-half partition of the table
For details, please refer to the attached 2:TRACK_PART19. The previous data partition can be deleted.
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART4
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART5
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART6
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART7
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART8
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART9
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART10
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART11
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART12
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART13
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART14
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART15
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART16
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART17
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART18
ALTER TABLE SEND_CONTROL_HIS1 DROP PARTITION TRACK_PART19
2. Clear the partition of the table in June
For details, please refer to the attached 2:TRACK_PART24. The previous data partition can be TRUNCATE.
ALTER TABLE SEND_CONTROL_HIS1 TRUNCATE PARTITION TRACK_PART20
ALTER TABLE SEND_CONTROL_HIS1 TRUNCATE PARTITION TRACK_PART21
ALTER TABLE SEND_CONTROL_HIS1 TRUNCATE PARTITION TRACK_PART22
ALTER TABLE SEND_CONTROL_HIS1 TRUNCATE PARTITION TRACK_PART23
ALTER TABLE SEND_CONTROL_HIS1 TRUNCATE PARTITION TRACK_PART24
