Oracle Database Discussions

Hello,


I have a procedure with a loop like this:


---------------------
loop
...
--set variable values for otable1 and otable2;
otable1 := 'tspace1.table1@dblink1';
otable2 := 'tspace2.table2@dblink2';
...
osql := 'insert into ' || otable1 || ' select * from ' || otable2;
...
execute immediate (osql)
...
commit;
end loop;
---------------------


This program worked until the number of loops increased and included several more servers and I got the error message ora-02020.


I have about ten servers, in which this procedure should be able to copy data from all ten servers over to one backup server.


I set init.ora -- open_links=500 -- on the server executing the dynamic SQL, which is not the source server or destination server.


Any suggestions are greatly appreciated