select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
alter table HBHE.TTTT1 MODIFY
 partition by range(TRX_DATE)
INTERVAL (numtoyminterval(1, 'month'))
(
partition P202203 values less than (to_date('2022-03-01','yyyy-mm-dd')),
partition P202204 values less than (to_date('2022-04-01','yyyy-mm-dd')),
partition P202205 values less than (to_date('2022-05-01','yyyy-mm-dd')),
partition P202206 values less than (to_date('2022-06-01','yyyy-mm-dd')),
partition P202207 values less than (to_date('2022-07-01','yyyy-mm-dd')),
partition P202208 values less than (to_date('2022-08-01','yyyy-mm-dd')),
partition P202209 values less than (to_date('2022-09-01','yyyy-mm-dd')),
partition P202210 values less than (to_date('2022-10-01','yyyy-mm-dd')),
partition P202211 values less than (to_date('2022-11-01','yyyy-mm-dd')),
partition P202212 values less than (to_date('2022-12-01','yyyy-mm-dd')),
partition P202301 values less than (to_date('2023-01-01','yyyy-mm-dd')),
partition P202302 values less than (to_date('2023-02-01','yyyy-mm-dd')),
partition P202303 values less than (to_date('2023-03-01','yyyy-mm-dd')),
partition P202304 values less than (to_date('2023-04-01','yyyy-mm-dd')),
partition P202305 values less than (to_date('2023-05-01','yyyy-mm-dd'))
) ONLINE update indexes parallel 8; 
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

表的行数:126002354
大小：45G
时间:2023-04-10 18:43:07 2023-04-10 19:03:37
期间产生大量的归档、redo、undo。需要实施的观察这些指标，即使的清理以及扩容。

官网链接:
https://docs.oracle.com/en/database/oracle/oracle-database/19/vldbg/evolve-nopartition-table.html#GUID-6054142E-207A-4DF0-A62A-4C1A94DD36C4http://www.cndba.cn/hbhe0316/article/116535http://www.cndba.cn/hbhe0316/article/116535http://www.cndba.cn/hbhe0316/article/116535http://www.cndba.cn/hbhe0316/article/116535

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle