利用ROWID批量提交,备份大数据大数据量表

利用ROWID批量提交,备份大数据大数据量表(rowid值依次递增，分配后的值不会再分配)
CREATE TABLE TEST.CF_BAK AS SELECT * FROM TEST.CF WHERE 1=2;--创建空表
DECLARE 
     V_MAX_ROWID INT;
     V_COUNT INT;
     V_ROWS INT :=100000;
BEGIN
     SELECT MAX(ROWID) INTO V_MAX_ROWID FROM TEST.CF;
     V_COUNT :=V_MAX_ROWID/V_ROWS+1;
     FOR i in 1..V_COUNT LOOP
     INSERT INTO TEST.CF_BAK SELECT * FROM TEST.CF WHERE ROWID>(i-1)*V_ROWS 
     AND ROWID<=i*V_ROWS;
     COMMIT; 
     END LOOP;
END