Re: Oracle to PostgreSQL Migration.

From: Neil Anderson <neil(at)postgrescompare(dot)com>
To: PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>
Cc: Chris Mair <chris(at)1006(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to PostgreSQL Migration.
Date: 2017-05-29 13:45:43
Message-ID: CAEKCySuXH4hZBy-=nAFvbZ=FvD2HszaNcXNAqFwYNkYJR3mkHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>
>>>
>> ya, but how can fix it.??
>>
>> because memory is not an issue on both the server.
>>
>

I've never used ora2pg but there is some documentation saying that
often an out of memory issue can be fixed by adjusting your DATA_LIMIT
setting. https://github.com/darold/ora2pg/blob/master/README#L307

> Hi Chris,
>
> I am able to get the output script in output.sql but now data migration is
> the big problem.

--
Neil Anderson
neil(at)postgrescompare(dot)com
https://www.postgrescompare.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-05-29 13:47:58 Re: Oracle to PostgreSQL Migration.
Previous Message PAWAN SHARMA 2017-05-29 13:40:17 Re: Oracle to PostgreSQL Migration.