| From: | Prestation3(dot)EXPLOITATION(at)nexans(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Out of memory using ora2pg |
| Date: | 2006-02-22 08:33:06 |
| Message-ID: | OF6DD2C05B.DDEB3D18-ONC125711D.002E97B9-C125711D.002EFA08@NEXANS.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thies C. Arntzen | 2006-02-22 09:07:53 | Re: TSearch2 from HEAD UTF8 German Compunds. |
| Previous Message | Teodor Sigaev | 2006-02-22 07:26:17 | Re: TSearch2 from HEAD UTF8 German Compunds. |