Thread: Oracle blob to Postgre bytea

Oracle blob to Postgre bytea

From

Chamath Sajeewa

Date:

23 July 2020, 07:53:17

Hi,

I have migrated a oracle table with blob column to postgres using ora2pg tool. How ever only 1mb of the blob data is migrated. Any idea?

Thank you!

Re: Oracle blob to Postgre bytea

From

Steve Baldwin

Date:

23 July 2020, 07:59:25

Reading this it looks like you need to set the LONGREADLEN environment variable. Are you doing that?

On Thu, Jul 23, 2020 at 2:53 PM Chamath Sajeewa <csgsajeewa@gmail.com> wrote:

Hi,
I have migrated a oracle table with blob column to postgres using ora2pg tool. How ever only 1mb of the blob data is migrated. Any idea?
Thank you!