From: | Prestation3(dot)EXPLOITATION(at)nexans(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Réf. : Re: Out of memory using ora2pg |
Date: | 2006-02-22 12:03:46 |
Message-ID: | OF0AD0B2F6.2E5B460A-ONC125711D.00421D9E-C125711D.004243AE@NEXANS.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks fro your answer ...
TRANSACTIONS has 55412 rows
to much ??
"E. Lefty Kreouzis" <lefty(at)rtfm(dot)gr>
22/02/2006 12:38
Pour : Prestation3(dot)EXPLOITATION(at)nexans(dot)com
cc : pgsql-general(at)postgresql(dot)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?
>
> http://archives.postgresql.org
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2006-02-22 13:04:58 | Re: Réf. : Re: [GENERAL] Out |
Previous Message | Alexander Schreiber | 2006-02-22 11:43:52 | Re: Postgresql Replication |