Prestation3.EXPLOITATION@xxxxxxxxxx wrote:
Thanks for the answer...
the configuration is as below:
Oracle ----> Ora2pg ----> PostgreSQL
Windows 2000 Linux Windows 2000
500 MB 3 GB 256 MB
Ora2pg.pl is executed on linux
top gives for porcess ora2pg.pl
VIRT RES
44272 28m
OK, so given your original error message:
"Dumping table TRANSACTIONS...
........................................................DBD::Pg::st
execute failed: ERROR: out of memory
DETAIL: Failed on request of size 16."
It looks to me like this is on your Windows box (256MB). This leads us
to two questions:
1. What is that machine showing for its memory usage?
2. What do the logs for PostgreSQL say on that machine?
--
Richard Huxton
Archonet Ltd
