IPS数据库日志表数据归档&表分区

IPS数据库日志CLOUD.SYS_OPER_LOG及其lob类型字段占用了大量数据库表空间。经过去业务确认，该日志数据存放一个月即可，之前的数据可以进行删除操作。
经过确认该表数据最早产生于2023年，有太多数据没进行清理，
考虑，如果使用delete 进行删除会产生大量日志，导致服务器异常（磁盘读写和使用率风险）
综上，确定方案：
    第一步：创建表结构与CLOUD.SYS_OPER_LOG一致的表CLOUD.SYS_OPER_LOG_2025(需要调整约束/索引名称)
    第二步：切换表：
>         CLOUD.SYS_OPER_LOG改名为CLOUD.SYS_OPER_LOG_HIS2025
>         CLOUD.SYS_OPER_LOG_2025改名为CLOUD.SYS_OPER_LOG

第三步：清理历史表（1个月后进行清理）
>         drop table CLOUD.SYS_OPER_LOG_HIS2025

操作步骤：
    第一步 建分区表：CLOUD.SYS_OPER_LOG_2025
>         create table CLOUD.SYS_OPER_LOG_2025
>         (
>           oper_id        NUMBER(20) not null,
>           title          VARCHAR2(200) default '',
>           business_type  NUMBER(2) default 0,
>           method         VARCHAR2(100) default '',
>           request_method VARCHAR2(10) default '',
>           operator_type  NUMBER(1) default 0,
>           oper_name      VARCHAR2(50) default '',
>           dept_name      VARCHAR2(50) default '',
>           oper_url       VARCHAR2(255) default '',
>           oper_ip        VARCHAR2(128) default '',
>           oper_location  VARCHAR2(255) default '',
>           status         NUMBER(1) default 0,
>           error_msg      VARCHAR2(4000) default '',
>           oper_time      DATE,
>           oper_param     VARCHAR2(4000),
>           sql_info       BLOB,
>           json_result    BLOB default ''
>         ) 
>         partition by range(oper_time)
>         (
>          partition p1 values less than(to_date('2025-08-01', 'yyyy-mm-dd')),
>          partition p2 values less than(to_date('2025-09-01', 'yyyy-mm-dd')),
>          partition p3 values less than(to_date('2025-10-01', 'yyyy-mm-dd')),
>          partition p4 values less than(to_date('2025-11-01', 'yyyy-mm-dd')),
>          partition p5 values less than(to_date('2025-12-01', 'yyyy-mm-dd')),
>          partition p6 values less than(to_date('2026-01-01', 'yyyy-mm-dd')),
>          partition p7 values less than(to_date('2026-02-01', 'yyyy-mm-dd')),
>          partition p8 values less than(to_date('2026-03-01', 'yyyy-mm-dd')),
>          partition p9 values less than(to_date('2026-04-01', 'yyyy-mm-dd')),
>          partition p10 values less than(to_date('2026-05-01', 'yyyy-mm-dd')),
>          partition p11 values less than(to_date('2026-06-01', 'yyyy-mm-dd')),
>          partition p12 values less than(to_date('2026-07-01', 'yyyy-mm-dd')),
>          partition p13 values less than(to_date('2026-08-01', 'yyyy-mm-dd')),
>          partition p14 values less than(to_date('2026-09-01', 'yyyy-mm-dd')),
>          partition p15 values less than(to_date('2026-10-01', 'yyyy-mm-dd')),
>          partition p16 values less than(to_date('2026-11-01', 'yyyy-mm-dd')),
>          partition p17 values less than(to_date('2026-12-01', 'yyyy-mm-dd')),
>          partition p18 values less than(to_date('2027-01-01', 'yyyy-mm-dd')),
>          partition p19 values less than(to_date('2027-02-01', 'yyyy-mm-dd')),
>          partition p20 values less than(to_date('2027-03-01', 'yyyy-mm-dd')),
>          partition p21 values less than(to_date('2027-04-01', 'yyyy-mm-dd')),
>          partition p22 values less than(to_date('2027-05-01', 'yyyy-mm-dd')),
>          partition p23 values less than(to_date('2027-06-01', 'yyyy-mm-dd')),
>         )
>         tablespace USERS
>           pctfree 10
>           initrans 1
>           maxtrans 255
>           storage
>           (
>             initial 64K
>             next 1M
>             minextents 1
>             maxextents unlimited
>           );
>         -- Add comments to the table 
>         comment on table CLOUD.SYS_OPER_LOG_2025
>           is '操作日志记录';
>         -- Add comments to the columns 
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_id
>           is '日志主键seq_SYS_OPER_LOG.nextval';
>         comment on column CLOUD.SYS_OPER_LOG_2025.title
>           is '模块标题';
>         comment on column CLOUD.SYS_OPER_LOG_2025.business_type
>           is '业务类型（0其它 1新增 2修改 3删除）';
>         comment on column CLOUD.SYS_OPER_LOG_2025.method
>           is '方法名称';
>         comment on column CLOUD.SYS_OPER_LOG_2025.request_method
>           is '请求方式';
>         comment on column CLOUD.SYS_OPER_LOG_2025.operator_type
>           is '操作类别（0其它 1后台用户 2手机端用户）';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_name
>           is '操作人员';
>         comment on column CLOUD.SYS_OPER_LOG_2025.dept_name
>           is '部门名称';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_url
>           is '请求URL';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_ip
>           is '主机地址';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_location
>           is '操作地点';
>         comment on column CLOUD.SYS_OPER_LOG_2025.status
>           is '操作状态（0正常 1异常）';
>         comment on column CLOUD.SYS_OPER_LOG_2025.error_msg
>           is '错误消息';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_time
>           is '操作时间';
>         comment on column CLOUD.SYS_OPER_LOG_2025.oper_param
>           is '请求参数';
>         comment on column CLOUD.SYS_OPER_LOG_2025.sql_info
>           is 'sql语句';
>         comment on column CLOUD.SYS_OPER_LOG_2025.json_result
>           is '返回参数';
>         -- Create/Recreate indexes 
>         create index CLOUD.SYS_OPER_LOG_2025_OPER_TIME on CLOUD.SYS_OPER_LOG_2025 (OPER_TIME)
>           tablespace USERS
>           pctfree 10
>           initrans 2
>           maxtrans 255
>           storage
>           (
>             initial 64K
>             next 1M
>             minextents 1
>             maxextents unlimited
>           );
>         -- Create/Recreate primary, unique and foreign key constraints 
>         alter table CLOUD.SYS_OPER_LOG_2025
>           add primary key (OPER_ID)
>           using index 
>           tablespace USERS
>           pctfree 10
>           initrans 2
>           maxtrans 255
>           storage
>           (
>             initial 64K
>             next 1M
>             minextents 1
>             maxextents unlimited
>           );

第二步 切换成分区表：(需要conn cloud/xxx)
>         ALTER TABLE SYS_OPER_LOG RENAME TO SYS_OPER_LOG_HIS2025;
>         ALTER TABLE SYS_OPER_LOG_2025 RENAME TO SYS_OPER_LOG;
> 
第三步 清理历史表：
>         drop table CLOUD.SYS_OPER_LOG_HIS2025