Re: Oracle blob to Postgre bytea

From: Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com>
To: Chamath Sajeewa <csgsajeewa(at)gmail(dot)com>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Oracle blob to Postgre bytea
Date: 2020-07-23 04:59:25
Message-ID: CAKE1AibM9t7HfoEtgfXH=9hdA=g3JaACb+EEkdBEWi0JMLA4sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Reading this <https://github.com/darold/ora2pg/issues/100> 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(at)gmail(dot)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!
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Preuß 2020-07-23 13:06:35 Copy SQL from main window to query tool
Previous Message Chamath Sajeewa 2020-07-23 04:53:17 Oracle blob to Postgre bytea