按天批量创建间隔分区表(DM8:达梦数据库)

DM8:达梦数据库-按天批量创建间隔分区表

  • 环境介绍
  • 1 生成按天批量创建间隔分区表的日志
  • 2 整合后的日志信息
  • 3 创建成功
  • 4 达梦数据库学习使用列表

环境介绍

  • 由于未知原因限制,按天批量创建间隔分区表最大是103行记录,需要反复执行几次,提取日志,整合后最终创建成功;

1 生成按天批量创建间隔分区表的日志

DECLARE
CT VARCHAR :='CREATE TABLE TDAY99(ID INT,NAME VARCHAR(20),BIR TIMESTAMP) '; --建表语句
PAR VARCHAR:= 'PARTITION BY RANGE(BIR) INTERVAL(NUMTODSINTERVAL(''1'',''DAY''))('; --配置分区列,和分区间隔
V_DATE VARCHAR :='''2023-01-01 00:00:00''';    --配置间隔分区初始分区
P_SUMDAY INT:=103;--配置间隔分区天数(单次最大执行103天)
V_END VARCHAR:=') STORAGE(ON "CESHI01_DATA", CLUSTERBTR);';    --配置表空间
V_DATE2 VARCHAR :='SELECT TO_DATE('||V_DATE||','||'''YYYY-MM-DD HH24:MI:SS'')';
V_DATE3 VARCHAR;
V_DATE4 VARCHAR;
P_NAME_YEAR VARCHAR;
P_NAME_MONTH VARCHAR;
P_NAME_DAY VARCHAR;
PAR2 VARCHAR;
PAR3 VARCHAR;
PAR4 VARCHAR;
BEGIN
   EXECUTE IMMEDIATE V_DATE2 INTO V_DATE3;
   P_NAME_YEAR := SUBSTR(V_DATE3,1,4);
   P_NAME_MONTH := SUBSTR(V_DATE3,6,2);
   P_NAME_DAY := SUBSTR(V_DATE3,9,2);
   PAR2 :='PARTITION P'||P_NAME_YEAR||P_NAME_MONTH||P_NAME_DAY||' VALUES LESS THAN (TO_DATE('||V_DATE||',''YYYY-MM-DD HH24:MI:SS''))';
    V_DATE4 := V_DATE;
    PRINT CT||PAR||PAR2;
    for I IN 2..P_SUMDAY LOOP
        V_DATE4 :='SELECT TO_DATE('||V_DATE4||','||'''YYYY-MM-DD HH24:MI:SS'')'||'+1';
        EXECUTE IMMEDIATE V_DATE4 INTO V_DATE3;
        V_DATE3:=''''||V_DATE3||'''';
        P_NAME_YEAR := SUBSTR(V_DATE3,2,4);
           P_NAME_MONTH := SUBSTR(V_DATE3,7,2);
           P_NAME_DAY := SUBSTR(V_DATE3,10,2);
        PAR3 :=',PARTITION P'||P_NAME_YEAR||P_NAME_MONTH||P_NAME_DAY||' VALUES LESS THAN (TO_DATE('||V_DATE3||',''YYYY-MM-DD HH24:MI:SS''))';
        PRINT PAR3;
        V_DATE4 := V_DATE3;
        PAR4 := PAR4||PAR3;
    END LOOP;
    PRINT V_END;
    
END;

2 整合后的日志信息

CREATE TABLE TDAY99(ID INT,NAME VARCHAR(20),BIR TIMESTAMP) PARTITION BY RANGE(BIR) INTERVAL(NUMTODSINTERVAL('1','DAY'))(PARTITION P20230101 VALUES LESS THAN (TO_DATE('2023-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230102 VALUES LESS THAN (TO_DATE('2023-01-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230103 VALUES LESS THAN (TO_DATE('2023-01-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230104 VALUES LESS THAN (TO_DATE('2023-01-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230105 VALUES LESS THAN (TO_DATE('2023-01-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230106 VALUES LESS THAN (TO_DATE('2023-01-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230107 VALUES LESS THAN (TO_DATE('2023-01-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230108 VALUES LESS THAN (TO_DATE('2023-01-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230109 VALUES LESS THAN (TO_DATE('2023-01-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230110 VALUES LESS THAN (TO_DATE('2023-01-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230111 VALUES LESS THAN (TO_DATE('2023-01-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230112 VALUES LESS THAN (TO_DATE('2023-01-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230113 VALUES LESS THAN (TO_DATE('2023-01-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230114 VALUES LESS THAN (TO_DATE('2023-01-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230115 VALUES LESS THAN (TO_DATE('2023-01-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230116 VALUES LESS THAN (TO_DATE('2023-01-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230117 VALUES LESS THAN (TO_DATE('2023-01-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230118 VALUES LESS THAN (TO_DATE('2023-01-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230119 VALUES LESS THAN (TO_DATE('2023-01-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230120 VALUES LESS THAN (TO_DATE('2023-01-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230121 VALUES LESS THAN (TO_DATE('2023-01-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230122 VALUES LESS THAN (TO_DATE('2023-01-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230123 VALUES LESS THAN (TO_DATE('2023-01-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230124 VALUES LESS THAN (TO_DATE('2023-01-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230125 VALUES LESS THAN (TO_DATE('2023-01-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230126 VALUES LESS THAN (TO_DATE('2023-01-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230127 VALUES LESS THAN (TO_DATE('2023-01-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230128 VALUES LESS THAN (TO_DATE('2023-01-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230129 VALUES LESS THAN (TO_DATE('2023-01-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230130 VALUES LESS THAN (TO_DATE('2023-01-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230131 VALUES LESS THAN (TO_DATE('2023-01-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230201 VALUES LESS THAN (TO_DATE('2023-02-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230202 VALUES LESS THAN (TO_DATE('2023-02-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230203 VALUES LESS THAN (TO_DATE('2023-02-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230204 VALUES LESS THAN (TO_DATE('2023-02-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230205 VALUES LESS THAN (TO_DATE('2023-02-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230206 VALUES LESS THAN (TO_DATE('2023-02-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230207 VALUES LESS THAN (TO_DATE('2023-02-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230208 VALUES LESS THAN (TO_DATE('2023-02-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230209 VALUES LESS THAN (TO_DATE('2023-02-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230210 VALUES LESS THAN (TO_DATE('2023-02-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230211 VALUES LESS THAN (TO_DATE('2023-02-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230212 VALUES LESS THAN (TO_DATE('2023-02-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230213 VALUES LESS THAN (TO_DATE('2023-02-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230214 VALUES LESS THAN (TO_DATE('2023-02-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230215 VALUES LESS THAN (TO_DATE('2023-02-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230216 VALUES LESS THAN (TO_DATE('2023-02-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230217 VALUES LESS THAN (TO_DATE('2023-02-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230218 VALUES LESS THAN (TO_DATE('2023-02-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230219 VALUES LESS THAN (TO_DATE('2023-02-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230220 VALUES LESS THAN (TO_DATE('2023-02-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230221 VALUES LESS THAN (TO_DATE('2023-02-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230222 VALUES LESS THAN (TO_DATE('2023-02-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230223 VALUES LESS THAN (TO_DATE('2023-02-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230224 VALUES LESS THAN (TO_DATE('2023-02-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230225 VALUES LESS THAN (TO_DATE('2023-02-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230226 VALUES LESS THAN (TO_DATE('2023-02-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230227 VALUES LESS THAN (TO_DATE('2023-02-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230228 VALUES LESS THAN (TO_DATE('2023-02-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230301 VALUES LESS THAN (TO_DATE('2023-03-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230302 VALUES LESS THAN (TO_DATE('2023-03-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230303 VALUES LESS THAN (TO_DATE('2023-03-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230304 VALUES LESS THAN (TO_DATE('2023-03-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230305 VALUES LESS THAN (TO_DATE('2023-03-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230306 VALUES LESS THAN (TO_DATE('2023-03-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230307 VALUES LESS THAN (TO_DATE('2023-03-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230308 VALUES LESS THAN (TO_DATE('2023-03-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230309 VALUES LESS THAN (TO_DATE('2023-03-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230310 VALUES LESS THAN (TO_DATE('2023-03-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230311 VALUES LESS THAN (TO_DATE('2023-03-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230312 VALUES LESS THAN (TO_DATE('2023-03-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230313 VALUES LESS THAN (TO_DATE('2023-03-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230314 VALUES LESS THAN (TO_DATE('2023-03-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230315 VALUES LESS THAN (TO_DATE('2023-03-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230316 VALUES LESS THAN (TO_DATE('2023-03-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230317 VALUES LESS THAN (TO_DATE('2023-03-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230318 VALUES LESS THAN (TO_DATE('2023-03-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230319 VALUES LESS THAN (TO_DATE('2023-03-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230320 VALUES LESS THAN (TO_DATE('2023-03-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230321 VALUES LESS THAN (TO_DATE('2023-03-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230322 VALUES LESS THAN (TO_DATE('2023-03-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230323 VALUES LESS THAN (TO_DATE('2023-03-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230324 VALUES LESS THAN (TO_DATE('2023-03-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230325 VALUES LESS THAN (TO_DATE('2023-03-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230326 VALUES LESS THAN (TO_DATE('2023-03-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230327 VALUES LESS THAN (TO_DATE('2023-03-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230328 VALUES LESS THAN (TO_DATE('2023-03-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230329 VALUES LESS THAN (TO_DATE('2023-03-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230330 VALUES LESS THAN (TO_DATE('2023-03-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230331 VALUES LESS THAN (TO_DATE('2023-03-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230401 VALUES LESS THAN (TO_DATE('2023-04-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230402 VALUES LESS THAN (TO_DATE('2023-04-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230403 VALUES LESS THAN (TO_DATE('2023-04-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230404 VALUES LESS THAN (TO_DATE('2023-04-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230405 VALUES LESS THAN (TO_DATE('2023-04-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230406 VALUES LESS THAN (TO_DATE('2023-04-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230407 VALUES LESS THAN (TO_DATE('2023-04-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230408 VALUES LESS THAN (TO_DATE('2023-04-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230409 VALUES LESS THAN (TO_DATE('2023-04-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230410 VALUES LESS THAN (TO_DATE('2023-04-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230411 VALUES LESS THAN (TO_DATE('2023-04-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230412 VALUES LESS THAN (TO_DATE('2023-04-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230413 VALUES LESS THAN (TO_DATE('2023-04-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230414 VALUES LESS THAN (TO_DATE('2023-04-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230415 VALUES LESS THAN (TO_DATE('2023-04-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230416 VALUES LESS THAN (TO_DATE('2023-04-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230417 VALUES LESS THAN (TO_DATE('2023-04-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230418 VALUES LESS THAN (TO_DATE('2023-04-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230419 VALUES LESS THAN (TO_DATE('2023-04-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230420 VALUES LESS THAN (TO_DATE('2023-04-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230421 VALUES LESS THAN (TO_DATE('2023-04-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230422 VALUES LESS THAN (TO_DATE('2023-04-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230423 VALUES LESS THAN (TO_DATE('2023-04-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230424 VALUES LESS THAN (TO_DATE('2023-04-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230425 VALUES LESS THAN (TO_DATE('2023-04-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230426 VALUES LESS THAN (TO_DATE('2023-04-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230427 VALUES LESS THAN (TO_DATE('2023-04-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230428 VALUES LESS THAN (TO_DATE('2023-04-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230429 VALUES LESS THAN (TO_DATE('2023-04-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230430 VALUES LESS THAN (TO_DATE('2023-04-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230501 VALUES LESS THAN (TO_DATE('2023-05-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230502 VALUES LESS THAN (TO_DATE('2023-05-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230503 VALUES LESS THAN (TO_DATE('2023-05-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230504 VALUES LESS THAN (TO_DATE('2023-05-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230505 VALUES LESS THAN (TO_DATE('2023-05-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230506 VALUES LESS THAN (TO_DATE('2023-05-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230507 VALUES LESS THAN (TO_DATE('2023-05-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230508 VALUES LESS THAN (TO_DATE('2023-05-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230509 VALUES LESS THAN (TO_DATE('2023-05-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230510 VALUES LESS THAN (TO_DATE('2023-05-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230511 VALUES LESS THAN (TO_DATE('2023-05-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230512 VALUES LESS THAN (TO_DATE('2023-05-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230513 VALUES LESS THAN (TO_DATE('2023-05-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230514 VALUES LESS THAN (TO_DATE('2023-05-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230515 VALUES LESS THAN (TO_DATE('2023-05-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230516 VALUES LESS THAN (TO_DATE('2023-05-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230517 VALUES LESS THAN (TO_DATE('2023-05-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230518 VALUES LESS THAN (TO_DATE('2023-05-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230519 VALUES LESS THAN (TO_DATE('2023-05-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230520 VALUES LESS THAN (TO_DATE('2023-05-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230521 VALUES LESS THAN (TO_DATE('2023-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230522 VALUES LESS THAN (TO_DATE('2023-05-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230523 VALUES LESS THAN (TO_DATE('2023-05-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230524 VALUES LESS THAN (TO_DATE('2023-05-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230525 VALUES LESS THAN (TO_DATE('2023-05-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230526 VALUES LESS THAN (TO_DATE('2023-05-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230527 VALUES LESS THAN (TO_DATE('2023-05-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230528 VALUES LESS THAN (TO_DATE('2023-05-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230529 VALUES LESS THAN (TO_DATE('2023-05-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230530 VALUES LESS THAN (TO_DATE('2023-05-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230531 VALUES LESS THAN (TO_DATE('2023-05-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230601 VALUES LESS THAN (TO_DATE('2023-06-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230602 VALUES LESS THAN (TO_DATE('2023-06-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230603 VALUES LESS THAN (TO_DATE('2023-06-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230604 VALUES LESS THAN (TO_DATE('2023-06-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230605 VALUES LESS THAN (TO_DATE('2023-06-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230606 VALUES LESS THAN (TO_DATE('2023-06-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230607 VALUES LESS THAN (TO_DATE('2023-06-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230608 VALUES LESS THAN (TO_DATE('2023-06-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230609 VALUES LESS THAN (TO_DATE('2023-06-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230610 VALUES LESS THAN (TO_DATE('2023-06-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230611 VALUES LESS THAN (TO_DATE('2023-06-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230612 VALUES LESS THAN (TO_DATE('2023-06-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230613 VALUES LESS THAN (TO_DATE('2023-06-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230614 VALUES LESS THAN (TO_DATE('2023-06-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230615 VALUES LESS THAN (TO_DATE('2023-06-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230616 VALUES LESS THAN (TO_DATE('2023-06-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230617 VALUES LESS THAN (TO_DATE('2023-06-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230618 VALUES LESS THAN (TO_DATE('2023-06-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230619 VALUES LESS THAN (TO_DATE('2023-06-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230620 VALUES LESS THAN (TO_DATE('2023-06-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230621 VALUES LESS THAN (TO_DATE('2023-06-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230622 VALUES LESS THAN (TO_DATE('2023-06-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230623 VALUES LESS THAN (TO_DATE('2023-06-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230624 VALUES LESS THAN (TO_DATE('2023-06-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230625 VALUES LESS THAN (TO_DATE('2023-06-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230626 VALUES LESS THAN (TO_DATE('2023-06-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230627 VALUES LESS THAN (TO_DATE('2023-06-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230628 VALUES LESS THAN (TO_DATE('2023-06-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230629 VALUES LESS THAN (TO_DATE('2023-06-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230630 VALUES LESS THAN (TO_DATE('2023-06-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230701 VALUES LESS THAN (TO_DATE('2023-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230702 VALUES LESS THAN (TO_DATE('2023-07-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230703 VALUES LESS THAN (TO_DATE('2023-07-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230704 VALUES LESS THAN (TO_DATE('2023-07-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230705 VALUES LESS THAN (TO_DATE('2023-07-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230706 VALUES LESS THAN (TO_DATE('2023-07-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230707 VALUES LESS THAN (TO_DATE('2023-07-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230708 VALUES LESS THAN (TO_DATE('2023-07-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230709 VALUES LESS THAN (TO_DATE('2023-07-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230710 VALUES LESS THAN (TO_DATE('2023-07-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230711 VALUES LESS THAN (TO_DATE('2023-07-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230712 VALUES LESS THAN (TO_DATE('2023-07-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230713 VALUES LESS THAN (TO_DATE('2023-07-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230714 VALUES LESS THAN (TO_DATE('2023-07-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230715 VALUES LESS THAN (TO_DATE('2023-07-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230716 VALUES LESS THAN (TO_DATE('2023-07-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230717 VALUES LESS THAN (TO_DATE('2023-07-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230718 VALUES LESS THAN (TO_DATE('2023-07-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230719 VALUES LESS THAN (TO_DATE('2023-07-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230720 VALUES LESS THAN (TO_DATE('2023-07-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230721 VALUES LESS THAN (TO_DATE('2023-07-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230722 VALUES LESS THAN (TO_DATE('2023-07-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230723 VALUES LESS THAN (TO_DATE('2023-07-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230724 VALUES LESS THAN (TO_DATE('2023-07-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230725 VALUES LESS THAN (TO_DATE('2023-07-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230726 VALUES LESS THAN (TO_DATE('2023-07-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230727 VALUES LESS THAN (TO_DATE('2023-07-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230728 VALUES LESS THAN (TO_DATE('2023-07-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230729 VALUES LESS THAN (TO_DATE('2023-07-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230730 VALUES LESS THAN (TO_DATE('2023-07-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230731 VALUES LESS THAN (TO_DATE('2023-07-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230801 VALUES LESS THAN (TO_DATE('2023-08-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230802 VALUES LESS THAN (TO_DATE('2023-08-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230803 VALUES LESS THAN (TO_DATE('2023-08-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230804 VALUES LESS THAN (TO_DATE('2023-08-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230805 VALUES LESS THAN (TO_DATE('2023-08-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230806 VALUES LESS THAN (TO_DATE('2023-08-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230807 VALUES LESS THAN (TO_DATE('2023-08-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230808 VALUES LESS THAN (TO_DATE('2023-08-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230809 VALUES LESS THAN (TO_DATE('2023-08-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230810 VALUES LESS THAN (TO_DATE('2023-08-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230811 VALUES LESS THAN (TO_DATE('2023-08-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230812 VALUES LESS THAN (TO_DATE('2023-08-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230813 VALUES LESS THAN (TO_DATE('2023-08-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230814 VALUES LESS THAN (TO_DATE('2023-08-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230815 VALUES LESS THAN (TO_DATE('2023-08-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230816 VALUES LESS THAN (TO_DATE('2023-08-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230817 VALUES LESS THAN (TO_DATE('2023-08-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230818 VALUES LESS THAN (TO_DATE('2023-08-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230819 VALUES LESS THAN (TO_DATE('2023-08-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230820 VALUES LESS THAN (TO_DATE('2023-08-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230821 VALUES LESS THAN (TO_DATE('2023-08-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230822 VALUES LESS THAN (TO_DATE('2023-08-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230823 VALUES LESS THAN (TO_DATE('2023-08-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230824 VALUES LESS THAN (TO_DATE('2023-08-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230825 VALUES LESS THAN (TO_DATE('2023-08-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230826 VALUES LESS THAN (TO_DATE('2023-08-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230827 VALUES LESS THAN (TO_DATE('2023-08-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230828 VALUES LESS THAN (TO_DATE('2023-08-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230829 VALUES LESS THAN (TO_DATE('2023-08-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230830 VALUES LESS THAN (TO_DATE('2023-08-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230831 VALUES LESS THAN (TO_DATE('2023-08-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230901 VALUES LESS THAN (TO_DATE('2023-09-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230902 VALUES LESS THAN (TO_DATE('2023-09-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230903 VALUES LESS THAN (TO_DATE('2023-09-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230904 VALUES LESS THAN (TO_DATE('2023-09-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230905 VALUES LESS THAN (TO_DATE('2023-09-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230906 VALUES LESS THAN (TO_DATE('2023-09-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230907 VALUES LESS THAN (TO_DATE('2023-09-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230908 VALUES LESS THAN (TO_DATE('2023-09-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230909 VALUES LESS THAN (TO_DATE('2023-09-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230910 VALUES LESS THAN (TO_DATE('2023-09-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230911 VALUES LESS THAN (TO_DATE('2023-09-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230912 VALUES LESS THAN (TO_DATE('2023-09-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230913 VALUES LESS THAN (TO_DATE('2023-09-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230914 VALUES LESS THAN (TO_DATE('2023-09-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230915 VALUES LESS THAN (TO_DATE('2023-09-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230916 VALUES LESS THAN (TO_DATE('2023-09-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230917 VALUES LESS THAN (TO_DATE('2023-09-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230918 VALUES LESS THAN (TO_DATE('2023-09-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230919 VALUES LESS THAN (TO_DATE('2023-09-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230920 VALUES LESS THAN (TO_DATE('2023-09-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230921 VALUES LESS THAN (TO_DATE('2023-09-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230922 VALUES LESS THAN (TO_DATE('2023-09-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230923 VALUES LESS THAN (TO_DATE('2023-09-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230924 VALUES LESS THAN (TO_DATE('2023-09-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230925 VALUES LESS THAN (TO_DATE('2023-09-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230926 VALUES LESS THAN (TO_DATE('2023-09-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230927 VALUES LESS THAN (TO_DATE('2023-09-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230928 VALUES LESS THAN (TO_DATE('2023-09-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230929 VALUES LESS THAN (TO_DATE('2023-09-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20230930 VALUES LESS THAN (TO_DATE('2023-09-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231001 VALUES LESS THAN (TO_DATE('2023-10-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231002 VALUES LESS THAN (TO_DATE('2023-10-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231003 VALUES LESS THAN (TO_DATE('2023-10-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231004 VALUES LESS THAN (TO_DATE('2023-10-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231005 VALUES LESS THAN (TO_DATE('2023-10-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231006 VALUES LESS THAN (TO_DATE('2023-10-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231007 VALUES LESS THAN (TO_DATE('2023-10-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231008 VALUES LESS THAN (TO_DATE('2023-10-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231009 VALUES LESS THAN (TO_DATE('2023-10-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231010 VALUES LESS THAN (TO_DATE('2023-10-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231011 VALUES LESS THAN (TO_DATE('2023-10-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231012 VALUES LESS THAN (TO_DATE('2023-10-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231013 VALUES LESS THAN (TO_DATE('2023-10-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231014 VALUES LESS THAN (TO_DATE('2023-10-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231015 VALUES LESS THAN (TO_DATE('2023-10-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231016 VALUES LESS THAN (TO_DATE('2023-10-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231017 VALUES LESS THAN (TO_DATE('2023-10-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231018 VALUES LESS THAN (TO_DATE('2023-10-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231019 VALUES LESS THAN (TO_DATE('2023-10-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231020 VALUES LESS THAN (TO_DATE('2023-10-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231021 VALUES LESS THAN (TO_DATE('2023-10-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231022 VALUES LESS THAN (TO_DATE('2023-10-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231023 VALUES LESS THAN (TO_DATE('2023-10-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231024 VALUES LESS THAN (TO_DATE('2023-10-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231025 VALUES LESS THAN (TO_DATE('2023-10-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231026 VALUES LESS THAN (TO_DATE('2023-10-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231027 VALUES LESS THAN (TO_DATE('2023-10-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231028 VALUES LESS THAN (TO_DATE('2023-10-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231029 VALUES LESS THAN (TO_DATE('2023-10-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231030 VALUES LESS THAN (TO_DATE('2023-10-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231031 VALUES LESS THAN (TO_DATE('2023-10-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231101 VALUES LESS THAN (TO_DATE('2023-11-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231102 VALUES LESS THAN (TO_DATE('2023-11-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231103 VALUES LESS THAN (TO_DATE('2023-11-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231104 VALUES LESS THAN (TO_DATE('2023-11-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231105 VALUES LESS THAN (TO_DATE('2023-11-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231106 VALUES LESS THAN (TO_DATE('2023-11-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231107 VALUES LESS THAN (TO_DATE('2023-11-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231108 VALUES LESS THAN (TO_DATE('2023-11-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231109 VALUES LESS THAN (TO_DATE('2023-11-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231110 VALUES LESS THAN (TO_DATE('2023-11-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231111 VALUES LESS THAN (TO_DATE('2023-11-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231112 VALUES LESS THAN (TO_DATE('2023-11-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231113 VALUES LESS THAN (TO_DATE('2023-11-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231114 VALUES LESS THAN (TO_DATE('2023-11-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231115 VALUES LESS THAN (TO_DATE('2023-11-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231116 VALUES LESS THAN (TO_DATE('2023-11-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231117 VALUES LESS THAN (TO_DATE('2023-11-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231118 VALUES LESS THAN (TO_DATE('2023-11-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231119 VALUES LESS THAN (TO_DATE('2023-11-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231120 VALUES LESS THAN (TO_DATE('2023-11-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231121 VALUES LESS THAN (TO_DATE('2023-11-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231122 VALUES LESS THAN (TO_DATE('2023-11-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231123 VALUES LESS THAN (TO_DATE('2023-11-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231124 VALUES LESS THAN (TO_DATE('2023-11-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231125 VALUES LESS THAN (TO_DATE('2023-11-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231126 VALUES LESS THAN (TO_DATE('2023-11-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231127 VALUES LESS THAN (TO_DATE('2023-11-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231128 VALUES LESS THAN (TO_DATE('2023-11-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231129 VALUES LESS THAN (TO_DATE('2023-11-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231130 VALUES LESS THAN (TO_DATE('2023-11-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231201 VALUES LESS THAN (TO_DATE('2023-12-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231202 VALUES LESS THAN (TO_DATE('2023-12-02 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231203 VALUES LESS THAN (TO_DATE('2023-12-03 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231204 VALUES LESS THAN (TO_DATE('2023-12-04 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231205 VALUES LESS THAN (TO_DATE('2023-12-05 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231206 VALUES LESS THAN (TO_DATE('2023-12-06 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231207 VALUES LESS THAN (TO_DATE('2023-12-07 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231208 VALUES LESS THAN (TO_DATE('2023-12-08 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231209 VALUES LESS THAN (TO_DATE('2023-12-09 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231210 VALUES LESS THAN (TO_DATE('2023-12-10 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231211 VALUES LESS THAN (TO_DATE('2023-12-11 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231212 VALUES LESS THAN (TO_DATE('2023-12-12 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231213 VALUES LESS THAN (TO_DATE('2023-12-13 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231214 VALUES LESS THAN (TO_DATE('2023-12-14 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231215 VALUES LESS THAN (TO_DATE('2023-12-15 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231216 VALUES LESS THAN (TO_DATE('2023-12-16 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231217 VALUES LESS THAN (TO_DATE('2023-12-17 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231218 VALUES LESS THAN (TO_DATE('2023-12-18 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231219 VALUES LESS THAN (TO_DATE('2023-12-19 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231220 VALUES LESS THAN (TO_DATE('2023-12-20 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231221 VALUES LESS THAN (TO_DATE('2023-12-21 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231222 VALUES LESS THAN (TO_DATE('2023-12-22 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231223 VALUES LESS THAN (TO_DATE('2023-12-23 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231224 VALUES LESS THAN (TO_DATE('2023-12-24 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231225 VALUES LESS THAN (TO_DATE('2023-12-25 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231226 VALUES LESS THAN (TO_DATE('2023-12-26 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231227 VALUES LESS THAN (TO_DATE('2023-12-27 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231228 VALUES LESS THAN (TO_DATE('2023-12-28 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231229 VALUES LESS THAN (TO_DATE('2023-12-29 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231230 VALUES LESS THAN (TO_DATE('2023-12-30 00:00:00','YYYY-MM-DD HH24:MI:SS'))
,PARTITION P20231231 VALUES LESS THAN (TO_DATE('2023-12-31 00:00:00','YYYY-MM-DD HH24:MI:SS'))

) STORAGE(ON "CESHI01_DATA", CLUSTERBTR);

3 创建成功

在这里插入图片描述

在这里插入图片描述

4 达梦数据库学习使用列表

  • 达梦数据库学习使用列表 - - 点击跳转

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：/a/232950.html

如若内容造成侵权/违法违规/事实不符，请联系我们进行投诉反馈qq邮箱809451989@qq.com，一经查实，立即删除！

相关文章

AGILE-SCRUM

AGILE-SCRUM

一个复杂的汽车ECU开发。当时开发队伍遍布全球7个国家，10多个地区，需要同时为多款车型定制不同的软件，头疼的地方是： 涉及到多方人员协调，多模块集成和管理不同软件团队使用的设计工具、验证工具，数据、工…
阅读更多...
python安装与工具PyCharm

python安装与工具PyCharm

摘要： 周末闲来无事学习一下python！不是你菜鸡，只不过是对手太强了！所以你要不断努力，去追求更高的未来！下面先了解python与环境的安装与工具的配置！ python安装： 官网 进入官网下载…
阅读更多...
【Linux】输出缓冲区和fflush刷新缓冲区

【Linux】输出缓冲区和fflush刷新缓冲区

目录 一、输出缓冲区 1.1 输出缓冲区的使用 1.2 缓冲区的刷新 1.3 输出缓冲区的作用 二、回车换行 一、输出缓冲区 C/C语言，当调用输出函数（如printf()、puts()、fwrite()等）时，会给我们提供默认的缓冲区。这些数据先存…
阅读更多...
Python绘制多分类ROC曲线

Python绘制多分类ROC曲线

目录 1 数据集介绍 1.1 数据集简介 1.2 数据预处理 2随机森林分类 2.1 数据加载 2.2 参数寻优 2.3 模型训练与评估 3 绘制十分类ROC曲线 第一步，计算每个分类的预测结果概率 第二步，画图数据准备 第三步，绘制十分类ROC曲线 1 数据集…
阅读更多...
C++学习笔记之五（String类）

C++学习笔记之五（String类）

C 前言getlinelength, sizec_strappend, inserterasefindsubstrisspace, isdigit 前言 C是兼容C语言的，所以C的字符串自然继承C语言的一切字符串，但它也衍生出属于自己的字符串类，即String类。String更像是一个容器，但它与容器还…
阅读更多...
uniapp如何制作一个收缩通讯录（布局篇)

uniapp如何制作一个收缩通讯录（布局篇)

html&#xff1a; <view class"search"><view class"search_padding"><u-search change"search" placeholder"请输入成员名称" v-model"keyword"></u-search></view></view> <view…
阅读更多...
【面试经典150 | 二叉树】从中序与后序遍历序列构造二叉树

【面试经典150 | 二叉树】从中序与后序遍历序列构造二叉树

文章目录 写在前面Tag题目来源题目解读解题思路方法一&#xff1a;递归 写在最后 写在前面 本专栏专注于分析与讲解【面试经典150】算法&#xff0c;两到三天更新一篇文章&#xff0c;欢迎催更…… 专栏内容以分析题目为主&#xff0c;并附带一些对于本题涉及到的数据结构等内容…
阅读更多...
2020年第九届数学建模国际赛小美赛A题自由泳解题全过程文档及程序

2020年第九届数学建模国际赛小美赛A题自由泳解题全过程文档及程序

2020年第九届数学建模国际赛小美赛 A题 自由泳 原题再现&#xff1a; 在所有常见的游泳泳姿中&#xff0c;哪一种最快&#xff1f;哪个冲程推力最大&#xff1f;在自由泳项目中&#xff0c;游泳者可以选择他们的泳姿&#xff0c;他们通常选择前面的爬行。然而&#xff0c;游泳…
阅读更多...
中文分词演进（查词典，hmm标注，无监督统计）新词发现

中文分词演进（查词典，hmm标注，无监督统计）新词发现

查词典和字标注 目前中文分词主要有两种思路&#xff1a;查词典和字标注。 首先&#xff0c;查词典的方法有&#xff1a;机械的最大匹配法、最少词数法&#xff0c;以及基于有向无环图的最大概率组合&#xff0c;还有基于语言模型的最大概率组合&#xff0c;等等。 查词典的方法…
阅读更多...
esxi全称“VMware ESXi

esxi全称“VMware ESXi

esxi全称“VMware ESXi”&#xff0c;是可直接安装在物理服务器上的强大的裸机管理系统&#xff0c;是一款虚拟软件&#xff1b;ESXi本身可以看做一个操作系统&#xff0c;采用Linux内核&#xff0c;安装方式为裸金属方式&#xff0c;可直接安装在物理服务器上&#xff0c;不需…
阅读更多...
TCP传输数据的确认机制

TCP传输数据的确认机制

实际的TCP收发数据的过程是双向的。 TCP采用这样的方式确认对方是否收到了数据&#xff0c;在得到对方确认之前&#xff0c;发送过的包都会保存在发送缓冲区中。如果对方没有返回某些包对应的ACK号&#xff0c;那么就重新发送这些包。 这一机制非常强大。通过这一机制&#xf…
阅读更多...
Redis如何做内存优化？

Redis如何做内存优化？

Redis如何做内存优化&#xff1f; 1、缩短键值的长度 缩短值的长度才是关键&#xff0c;如果值是一个大的业务对象&#xff0c;可以将对象序列化成二进制数组&#xff1b; 首先应该在业务上进行精简&#xff0c;去掉不必要的属性&#xff0c;避免存储一些没用的数据&#xff1…
阅读更多...
博途PLC SCL间接寻址编程应用

博途PLC SCL间接寻址编程应用

这篇博客里我们将要学习Pointer和Any指针&#xff0c;PEEK和POKE指令&#xff0c;当然我们还可以数组类型数据实现数组指针寻址&#xff0c;具体应用介绍请参考下面文章链接&#xff1a; https://rxxw-control.blog.csdn.net/article/details/134761364https://rxxw-control.b…
阅读更多...
15.Java程序设计-基于SSM框架的微信小程序校园求职系统的设计与实现

15.Java程序设计-基于SSM框架的微信小程序校园求职系统的设计与实现

摘要&#xff1a; 本研究旨在设计并实现一款基于SSM框架的微信小程序校园求职系统&#xff0c;以提升校园求职流程的效率和便捷性。通过整合微信小程序平台和SSM框架的优势&#xff0c;本系统涵盖了用户管理、职位发布与搜索、简历管理、消息通知等多个功能模块&#xff0c;为…
阅读更多...
分子生成领域的stable diffusion - GEOLDM

分子生成领域的stable diffusion - GEOLDM

一、关于stable diffusion 很多人都知道stable diffusion&#xff0c;stable diffusion的出现改变了机器生成领域&#xff0c;让AI技术第一次无比的接近正常人。大语言模型&#xff0c;AIGC概念于是兴起。基于stable diffusion 大家开发了lora&#xff0c; hyperwork等微调技术…
阅读更多...
【VS Code】Visual Studio Code 你必须安装的 Plugins - 持续更新

【VS Code】Visual Studio Code 你必须安装的 Plugins - 持续更新

文章目录 GitLens — Git supercharged【真香】EditorConfig for VS Code【真香】Remote - SSH【真香】MySQL【真香】 Talk is cheap, show me the code. GitLens — Git supercharged【真香】 插件地址&#xff1a; https://marketplace.visualstudio.com/items?itemNameeam…
阅读更多...
C语言有哪些预处理操作？

C语言有哪些预处理操作？

C语言的预处理是在编译之前对源代码进行处理的阶段&#xff0c;它主要由预处理器完成。预处理器是一个独立的程序&#xff0c;它负责对源代码进行一些文本替换和处理&#xff0c;生成经过预处理的代码。以下是C语言预处理的一些重要特性&#xff1a; 1&#xff0c;头文件包含 #…
阅读更多...
侮辱性涨薪！业绩得了S，调薪涨了450

侮辱性涨薪！业绩得了S，调薪涨了450

信安这个行业3年前各大媒体&#xff0c;信安自己人都觉得自己在个朝阳行业&#xff0c;红利在咋弄不得再吃5年。 现在拉个干网络安全的再去问问&#xff0c;看看谁不是去年年终奖砍了一半、或者根本就没了&#xff0c;再或者每天岌岌可危生怕去领大礼包。 原本10月份的激励性…
阅读更多...
python变量的命名和使用

python变量的命名和使用

变量名只能包含字母、数字和下划线 变量名只能包含字母、数字和下划线。变量名可以字母或下划线打头&#xff0c;但不能以数字打头。例如&#xff0c;可将变量命名为message_1&#xff0c;但不能将其命名为1_message。 Python 语言中&#xff0c;以下划线开头的标识符有特殊含…
阅读更多...
Android 相机库CameraView源码解析 (五) : 保存滤镜效果

Android 相机库CameraView源码解析 (五) : 保存滤镜效果

1. 前言 这段时间&#xff0c;在使用 natario1/CameraView 来实现带滤镜的预览、拍照、录像功能。 由于CameraView封装的比较到位&#xff0c;在项目前期&#xff0c;的确为我们节省了不少时间。 但随着项目持续深入&#xff0c;对于CameraView的使用进入深水区&#xff0c;逐…
阅读更多...
最新文章

Copyright @ 2022~2023