Re: Oracle to postgres migration via ora2pg (blob data)

2019-07-31 Thread Gilles Darold
k > the details up. > >   > > Niels > >   > >   > > *Fra:* Daulat Ram <mailto:daulat@exponential.com>> > *Sendt:* 31. juli 2019 13:32 > *Til:* pgsql-gene...@lists.postgresql.org > <mailto:pgsql-gene...@lists.p

Oracle to postgres migration via ora2pg (blob data)

2019-07-31 Thread Daulat Ram
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 LOBSEGME

Re: Oracle to postgres migration via ora2pg (blob data)

2019-07-31 Thread Amol Tarte
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 > *Sendt:* 31. juli 2019 13:32 > *Til:* pgsql-gene...@lists.postgresql.org; > pgsql-perfor

SV: Oracle to postgres migration via ora2pg (blob data)

2019-07-31 Thread Niels Jespersen
(SYS_LOB095961C8$$); -- 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 Sendt: 31. juli 2019 13:32 Til: pgsql-gene...@lists.postgresql.org; pgsql-performance@lists.postgresql.org Emne: Oracle to postgres migration via

Re: Oracle to postgres migration

2019-04-08 Thread David G. Johnston
On Mon, Apr 8, 2019 at 3:31 PM Gavin Flower wrote: > I think having a specific migration group would also be likely to > improve the visibility of pg, and the idea of migrating to pg. As it > help pg to appear in more search results. > > I presently have qualms retaining novice, sql, performance

Re: Oracle to postgres migration

2019-04-08 Thread Gavin Flower
On 09/04/2019 08:02, legrand legrand wrote: Rick Otten-2 wrote On Mon, Apr 8, 2019 at 8:04 AM Julien Rouhaud < rjuju123@ > wrote: [...] That said, none of this is on topic for the performance mailing list. Please try to direct your questions to the right group next time. Is "general" the corr

Re: Oracle to postgres migration

2019-04-08 Thread legrand legrand
Rick Otten-2 wrote > On Mon, Apr 8, 2019 at 8:04 AM Julien Rouhaud < > rjuju123@ > > wrote: > > [...] > > That said, none of this is on topic for the performance mailing list. > Please try to direct your questions to the right group next time. Is "general" the correct one ? or should a "migrat

Re: Oracle to postgres migration

2019-04-08 Thread phb07
Le 08/04/2019 à 14:24, Rick Otten a écrit : On Mon, Apr 8, 2019 at 8:04 AM Julien Rouhaud > wrote: On Mon, Apr 8, 2019 at 1:49 PM Daulat Ram mailto:daulat@exponential.com>> wrote: > > Please confirm ! Can we migrate Oracle 12c database (12.1

Re: Oracle to postgres migration

2019-04-08 Thread Rick Otten
On Mon, Apr 8, 2019 at 8:04 AM Julien Rouhaud wrote: > On Mon, Apr 8, 2019 at 1:49 PM Daulat Ram > wrote: > > > > Please confirm ! Can we migrate Oracle 12c database (12.1.0.1.0) running > on Solaris to PostgreSQL 11.2 on Linux (Ubuntu). Also, please suggest the > tools and pre-requisites. > A

Re: Oracle to postgres migration

2019-04-08 Thread Julien Rouhaud
On Mon, Apr 8, 2019 at 1:49 PM Daulat Ram wrote: > > Please confirm ! Can we migrate Oracle 12c database (12.1.0.1.0) running on > Solaris to PostgreSQL 11.2 on Linux (Ubuntu). Also, please suggest the tools > and pre-requisites. A database migration is likely feasible, but might require quite

Oracle to postgres migration

2019-04-08 Thread Daulat Ram
Hi team, Please confirm ! Can we migrate Oracle 12c database (12.1.0.1.0) running on Solaris to PostgreSQL 11.2 on Linux (Ubuntu). Also, please suggest the tools and pre-requisites. Regards, Daulat