declare
n_count integer := 0;
cursor cur_bak is
select ID,
MAC,
IP,
NETBAR_ID,
LOGIN_TIMES,
LOGIN_DATE,
GAME_ID,
PROVINCE,
CITY
from SYS_LOGIN_RECORDS_DETAIL_BAK;
begin
for i_cur_bak in cur_bak loop
insert into SYS_LOGIN_RECORDS_DETAIL
(ID,
MAC,
IP,
NETBAR_ID,
LOGIN_TIMES,
LOGIN_DATE,
GAME_ID,
PROVINCE,
CITY)
values
(i_cur_bak.id,
i_cur_bak.MAC,
i_cur_bak.IP,
i_cur_bak.NETBAR_ID,
i_cur_bak.LOGIN_TIMES,
i_cur_bak.LOGIN_DATE,
i_cur_bak.GAME_ID,
i_cur_bak.PROVINCE,
i_cur_bak.CITY);
n_count := n_count + 1;
if n_count >= 5000 then
commit;
n_count := 0;
end if;
end loop;
commit;
end;
/