...
- The process above needs to be repeated for the Network performance tables. Replace DATE below with the same target date as above in the format YYYY-MM-DD.
Code Block | ||
---|---|---|
| ||
select min(id) from net_device_perf_sample where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE'; |
- Use the ID from the previous command in place of ID in the following commands.
Code Block | ||
---|---|---|
| ||
delete from net_device_perf_ping where sample_id < ID; commit; delete from net_device_perf_port where sample_id < ID; commit; |
- The process above needs to be repeated for the retained performance tables. Replace DATE below with the same target date as above in the format YYYY-MM-DD.
Code Block | ||
---|---|---|
| ||
delete from erdc_decimal_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE'; delete from erdc_int_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE'; delete from erdc_string_data where TO_CHAR(sample_timesampletime,'YYYY-MM-DD') - 'DATE'; delete from ranged_object_value where TO_CHAR(sample_time,'YYYY-MM-DD') - 'DATE'; |