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

2019-07-31 Thread Gilles Darold
ostgresql.org>; > pgsql-performa...@lists.postgresql.org > <mailto:pgsql-performa...@lists.postgresql.org> > *Emne:* Oracle to postgres migration via ora2pg (blob data) > >   > > Hello team, > >   > > We have to migrate a schema from or

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-general@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-general@lists.postgresql.org; pgsql-performa...@lists.postgresql.org Emne: Oracle to postgres migration via

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