CREATETABLE"XXX"."TB_XXX_BAK"("PK_XXX" NUMBER NOTNULLENABLE,"X1" CLOB,"DT"DATEDEFAULT sysdate,CONSTRAINT"PK_XXX_BAK"PRIMARYKEY("PK_XXX")USINGINDEXTABLESPACE"USERS"ENABLE)
LOB ("X1") STORE AS SECUREFILE (COMPRESS DEDUPLICATE LOB)PARTITIONBY RANGE ("DT")(PARTITION p_min VALUES LESS THAN (TO_DATE('2019-01-01','yyyy-mm-dd'))TABLESPACE"USERS",PARTITION P_2019_01 VALUES LESS THAN (TO_DATE('2019-02-01','yyyy-mm-dd'))TABLESPACE"USERS") NOCOMPRESS LOGGING TABLESPACE"USERS";----declare
v_count number;begin
v_count :=0;for p in(select PK_XXX from XXX.TB_XXX where dt between to_date('20190101 00:00:00','YYYYMMDD HH24:MI:SS')and to_date('20190101 23:59:59','YYYYMMDD HH24:MI:SS'))loopinsertinto XXX.TB_XXX_BAK(select*from XXX.TB_XXX t1 where t1.PK_XXX= p.PK_XXX);
v_count := v_count +1;ifmod(v_count,500)=0thencommit;endif;endloop;commit;
dbms_output.put_line(to_char(v_count));end;