oracle 数据库通过job定时删除表分区

1、创建测试环境 test_part 表，并插入数据。CREATE TABLE test_part( create_time TIMESTAMP)PARTITION BY RANGE (create_time) INTERVAL (NUMTODSINTERVAL(1,'DAY'))(PARTITION create_time_other VALUES LESS THAN (TIMESTAMP' 2019-09-01 00:00:00')) ;insert into test_part values(to_date('2019-09-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));insert into test_part values(to_date('2019-09-02 00:00:00','YYYY-MM-DD HH24:MI:SS'));insert into test_part values(to_date('2019-09-03 00:00:00','YYYY-MM-DD HH24:MI:SS'));insert into test_part values(to_date('2019-09-04 00:00:00','YYYY-MM-DD HH24:MI:SS'));commit;

3、添加定时任务，每天1 点调用。BEGINDBMS_SCHEDULER.CREATE_JOB( job_name => 'delpart_job', job_type => 'PLSQL_BLOCK', job_action => 'delPart;', start_date => SYSDATE, repeat_interval => 'TRUNC(sysdate+1)+1/24');END;

5、手工调用job，检查job是否能够调用delPart 过程，并删除分区。begin dbms_scheduler.run_job('DELPART_JOB') ;end;