可以insert into ACCT_2022 select xx,xx from ACCT where 时间条件；

DECLARE
CURSOR CUR FOR SELECT * FROM “SYSDBA”.“ACCT” where time between ‘xx’ and ‘xx’;
TYPE TY_CUR IS TABLE OF CUR%ROWTYPE;
VV TY_CUR;
BEGIN
OPEN CUR;
LOOP
EXIT WHEN CUR%NOTFOUND;
FETCH CUR BULK COLLECT INTO VV LIMIT 10000;
FORALL I IN 1…VV.COUNT()
INSERT INTO “SYSDBA”.“ACCT_2022” VALUES VV(I);
COMMIT;
END LOOP;
commit;
CLOSE CUR;
END;
–之前写过使用游标的分批方式把结果集插入到另一张表中，看看能不能满足，这个是10000行一提交