Re: [GENERAL] Oracle to PostgreSQL Migration. - Mailing list pgsql-general

From Neil Anderson
Subject Re: [GENERAL] Oracle to PostgreSQL Migration.
Date
Msg-id CAEKCySuXH4hZBy-=nAFvbZ=FvD2HszaNcXNAqFwYNkYJR3mkHw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Oracle to PostgreSQL Migration.  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
List 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@postgrescompare.com
https://www.postgrescompare.com



pgsql-general by date:

Previous
From: PAWAN SHARMA
Date:
Subject: Re: [GENERAL] Oracle to PostgreSQL Migration.
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Oracle to PostgreSQL Migration.