Can't locate Ora2Pg.pm while executing export_schema.sh

From: "Pansara, Jiten" <Jiten(dot)Pansara(at)fisglobal(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Can't locate Ora2Pg.pm while executing export_schema.sh
Date: 2021-08-17 07:15:54
Message-ID: HE1PR08MB28267E0F46BBEE3B09562D8FEEFE9@HE1PR08MB2826.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Team,

I am getting below error while executing export_schema.sh. Any suggestion/help is really appreciated.

BEGIN failed--compilation aborted at /c/Strawberry/perl/site/bin/ora2pg line 27.
Can't locate Ora2Pg.pm in @INC (you may need to install the Ora2Pg module) (@INC contains: /usr/lib/perl5/site_perl /usr/share/perl5/site_perl /usr/lib/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib/perl5/core_perl /usr/share/perl5/core_perl) at /c/Strawberry/perl/site/bin/ora2pg line 27.
BEGIN failed--compilation aborted at /c/Strawberry/perl/site/bin/ora2pg line 27.

If we don't want to use this script, should we execute ora2pg directly to migrate the database from Oracle to Postgres?

* Ora2pg -c ora2pg.conf

Let me know your views.

Jiten Pansara
Senior Database Analyst
T: +91 9158149600
E: jiten(dot)pansara(at)fisglobal(dot)com<mailto:jiten(dot)pansara(at)fisglobal(dot)com>
FIS | Advancing the way the world Pays, Banks, and Invests [cid:image001(dot)png(at)01D79365(dot)CE59CA90] <https://www.facebook.com/FIStoday> [cid:image002(dot)png(at)01D79365(dot)CE59CA90] <https://twitter.com/FISGlobal> [cid:image003(dot)png(at)01D79365(dot)CE59CA90] <https://www.linkedin.com/company/fis>
[A picture containing text, outdoor, sign Description automatically generated]

The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Dauncey 2021-08-17 11:51:47 vacuumlo
Previous Message Shrikant Bhende 2021-08-17 03:25:33 Re: Join for the parent table will not leverage the index scan