Réf. : Re: Out of memory using ora2pg
Thanks fro your answer ...
TRANSACTIONS has 55412 rows
to much ??
"E. Lefty Kreouzis" <lefty@rtfm.gr>
22/02/2006 12:38
Pour : Prestation3.EXPLOITATION@nexans.com
cc : pgsql-general@postgresql.org
Objet : Re: [GENERAL] Out of memory using ora2pg
Hi,
I try to migrate an Oracle database 9.2.0.5 ( one schema)
to an Postgresql (8.1.3) database.
I use ora2pg to do this ...When I use it after a while I get the following error:
MONTANTTVARECUP => type:NUMBER , length:22, precision:, scale:,
nullable:Y , default:
DTCREA => type:DATE , length:7, precision:, scale:, nullable:Y ,
default:
[34] Scanning TYPECOMPTEBO ( USRWEB TYPECOMPTEBO TABLE )...
TYPE => type:VARCHAR2 , length:2, precision:, scale:, nullable:Y
,
default:
[35] Scanning TYPE_MATERIEL ( USRWEB TYPE_MATERIEL TABLE )...
ID_TYPE_MATERIEL => type:NUMBER , length:22, precision:,
scale:0,
nullable:N , default:
TYPE_MATERIEL => type:VARCHAR2 , length:20, precision:, scale:,
nullable:N , default:
Dumping table TRANSACTIONS...
........................................................DBD::Pg::st
execute failed: ERROR: out of memory
DETAIL: Failed on request of size 16.
ERROR: out of memory
DETAIL: Failed on request of size 16.Is it a problem with perl memory or posgresql memory ?
Can you hellp me please ?Thanks in advance ...
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
Ora2Pg uses DBI which fetches all rows from the database on select. How
many rows does the TRANSACTIONS table have?
Lefty Kreouzis
--
Me myself & I