Oracle to postgres migration via ora2pg (blob data)

From: Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Oracle to postgres migration via ora2pg (blob data)
Date: 2019-07-31 11:31:45
Message-ID: BL0PR01MB518710314423C7CB8756DD449BDF0@BL0PR01MB5187.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Hello team,

We have to migrate a schema from oracle to postgres but there is one table that is having following large lob segments. This table is taking time to export. What parameters we have to set in ora2pg.conf to speed up the data export by ora2pg.

Table: CLIENT_DB_AUDIT_LOG

LOBSEGMENT SYS_LOB0000095961C00008$$ 80.26
LOBSEGMENT SYS_LOB0000095961C00007$$ 79.96
LOBSEGMENT SYS_LOB0000094338C00008$$ 8.84
LOBSEGMENT SYS_LOB0000084338C00007$$ 8.71
LOBSEGMENT SYS_LOB0000085961C00009$$ 5.32

VM Details are:

RAM 8GB
VCPUs 2 VCPU
Disk 40GB

Thanks,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Niels Jespersen 2019-07-31 11:45:58 SV: Oracle to postgres migration via ora2pg (blob data)
Previous Message Luca Ferrari 2019-07-31 11:21:53 pgaudit.log_parameter

Browse pgsql-performance by date

  From Date Subject
Next Message Niels Jespersen 2019-07-31 11:45:58 SV: Oracle to postgres migration via ora2pg (blob data)
Previous Message Holger Jakobs 2019-07-31 09:45:13 Re: A question regarding streaming replication