ORA-01062: unable to allocate memory for define buffer Cause: Exceeded the maximum buffer size for current plaform Action: Use piecewise fetch with a smaller buffer size
ORA-01062: unable to allocate memory for define buffer Cause: Exceeded the maximum buffer size for current plaform
Action: Use piecewise fetch with a smaller buffer size
你的long撑死了buffer size 试试加大buffer_cache_size alter system set buffer_cache_size=1000M
试试调整 arraysize 和 copycommit 变量设置如,每次复制 10 行并提交 > set arraysize 10 > set copycommit 1
create or replace procedure testcopy is cursor c is select * from sourseTable; begin for rec in c loop insert into targetTable(id,longColumn) values(rec.id,rec.longColumn) ; end loop; commit; end testcopy; 写存储过程,用游标来做
Cause: Exceeded the maximum buffer size for current plaform
Action: Use piecewise fetch with a smaller buffer size
ORA-01062: unable to allocate memory for define buffer
Cause: Exceeded the maximum buffer size for current plaform
Action: Use piecewise fetch with a smaller buffer size
试试加大buffer_cache_size
alter system set buffer_cache_size=1000M
> set arraysize 10
> set copycommit 1
is
cursor c is select * from sourseTable;
begin
for rec in c loop
insert into targetTable(id,longColumn) values(rec.id,rec.longColumn) ;
end loop;
commit;
end testcopy; 写存储过程,用游标来做