From: | Amol Tarte <amoltarte(at)gmail(dot)com> |
---|---|
To: | Niels Jespersen <NJN(at)dst(dot)dk> |
Cc: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>, "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: | Re: Oracle to postgres migration via ora2pg (blob data) |
Date: | 2019-07-31 16:02:10 |
Message-ID: | CAOavZFT4xdabOU67Gdr=-YFnsiEpks7Nuq28KqhcPs1v1Bpm+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
FullConvert does this job much faster than ora2pg
With Warm Regards,
Amol Tarte,
Project Lead,
Rajdeep InfoTechno Pvt. Ltd.
Visit us at http://it.rajdeepgroup.com
On Wed 31 Jul, 2019, 5:16 PM Niels Jespersen, <NJN(at)dst(dot)dk> wrote:
> I would look at the source table in Oracle first. It looks a lot like
> audit data. Perhaps all content is not needed in Postgres. If it is, then
> the table and lobs may benefit from being reorganised in oracle.
>
>
>
> Alter table CLIENT_DB_AUDIT_LOG move;
>
> Alter table CLIENT_DB_AUDIT_LOG move lob (SYS_LOB0000095961C00008$$);
>
> -- Three more of these.
>
>
>
> The syntax is from my the back of my head. You may need to look the
> details up.
>
>
>
> Niels
>
>
>
>
>
> *Fra:* Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com>
> *Sendt:* 31. juli 2019 13:32
> *Til:* pgsql-general(at)lists(dot)postgresql(dot)org;
> pgsql-performance(at)lists(dot)postgresql(dot)org
> *Emne:* Oracle to postgres migration via ora2pg (blob data)
>
>
>
> 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,
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2019-07-31 16:19:17 | Re: Which version to upgrade upto |
Previous Message | David G. Johnston | 2019-07-31 16:00:53 | Re: Which version to upgrade upto |
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles Darold | 2019-07-31 21:05:28 | Re: Oracle to postgres migration via ora2pg (blob data) |
Previous Message | Niels Jespersen | 2019-07-31 11:45:58 | SV: Oracle to postgres migration via ora2pg (blob data) |