RE: EXTERNAL: Re: Could not startup new database - Oracle to Postgres Migration error.

: Monday, August 16, 2021 2:41 PM To: Pansara, Jiten Cc: pgsql-general@lists.postgresql.org Subject: EXTERNAL: Re: Could not startup new database - Oracle to Postgres Migration error. CAUTION: This email originated from outside of the company. Do not click links or open attachments unless y

Re: EXTERNAL: Re: Could not startup new database - Oracle to Postgres Migration error.

On Mon, Aug 16, 2021 at 5:16 PM Pansara, Jiten wrote: > > Thanks a lot for quick response. I can see below after executing the Perl > command given by you. > > PS C:\ora2pg-22.1> perl -e "use DBD::Pg" > PS C:\ora2pg-22.1> It means that you already have DBD::Pg installed.

Re: Could not startup new database - Oracle to Postgres Migration error.

On Mon, Aug 16, 2021 at 4:46 PM Pansara, Jiten wrote: > > I was following Ora2Pg : Migrates Oracle to PostgreSQL (darold.net) to > migrate the db and am stuck when trying to execute below command. > > perl -MCPAN -e 'install DBD::Pg' It would be better to send the error in plain text rather than

Could not startup new database - Oracle to Postgres Migration error.

Hello All, I am facing issue while migrating database from Oracle to Postgres. Any suggestions will be really appreciated. I was following Ora2Pg : Migrates Oracle to PostgreSQL (darold.net) to migrate the db and am stuck when trying to execute bel

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

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

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

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)

(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)

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

On Tue, Dec 26, 2017, at 02:30, Azimuddin Mohammed wrote: > Hello, > Can anyone guide me through the steps for migration from oracle to > postgres with config changes required, keeping in mind that neither I > am a oracle DBA not postgres admin> > -- > > Regards, > Azim > > > Virus-free. www.

Re: Oracle to postgres migration

On Tue, Dec 26, 2017, at 11:36, Vasilis Ventirozos wrote: > I'd start with this first : https://ora2pg.darold.net > >> On 26 Dec 2017, at 02:30, Azimuddin Mohammed >> wrote:>> >> Hello, >> Can anyone guide me through the steps for migration from oracle to >> postgres with config changes required

Re: Oracle to postgres migration

I'd start with this first : https://ora2pg.darold.net > On 26 Dec 2017, at 02:30, Azimuddin Mohammed wrote: > > Hello, > Can anyone guide me through the steps for migration from oracle to postgres > with config changes required, keeping in mind that neither I am a

Re: Oracle to postgres migration

Hi, May I first suggest that you first look at some of EnterpriseDB’s technical literature. They have some documents which list what their products add to PostgreSQL to make it more like Oracle. If your firm isn’t doing this just to get out of licensing fees, they would probably be a good opti

Oracle to postgres migration

Hello, Can anyone guide me through the steps for migration from oracle to postgres with config changes required, keeping in mind that neither I am a oracle DBA not postgres admin -- Regards, Azim