Out of memory using ora2pg

Поиск
Список
Период
Сортировка
От Prestation3.EXPLOITATION@nexans.com
Тема Out of memory using ora2pg
Дата
Msg-id OF6DD2C05B.DDEB3D18-ONC125711D.002E97B9-C125711D.002EFA08@NEXANS.COM
обсуждение исходный текст
Ответы Re: Out of memory using ora2pg  (Richard Huxton <dev@archonet.com>)
Re: Out of memory using ora2pg  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 ...


В списке pgsql-general по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: TSearch2 from HEAD UTF8 German Compunds.
Следующее
От: "Thies C. Arntzen"
Дата:
Сообщение: Re: TSearch2 from HEAD UTF8 German Compunds.