Re: Oracle to Postgres migration open source tool - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Oracle to Postgres migration open source tool
Date
Msg-id 20110707162945.GD56515@shinkuro.com
Whole thread Raw
In response to Re: Oracle to Postgres migration open source tool  (akp geek <akpgeek@gmail.com>)
List pgsql-general
On Thu, Jul 07, 2011 at 12:01:56PM -0400, akp geek wrote:
> Thank you all for the responses. All we have is just table migrations, no
> procedures, triggers involved. I will try to do the migration using ora2pg.
> I downloaded it, while installing it I am getting an error. Will try to
> resolve that and proceed
>
> Writing
> /export/home/postgres/perl_5_10_0/lib/perl5/site_perl/5.10.0/sun4-solaris/auto/Ora2Pg/.packlist
> sh install_all.sh
> install_all.sh: test: argument expected
> gmake: *** [install_all] Error 1

It tries to test using a bunch of Oracle modules, and those modules
install with some sort of fake dependency (ISTR it was $ORACLE_HOME,
but it's a dim memory now -- there was something about installing
client-only libraries IIRC).  So you have to bodge up your environment
to get the Perl modules installed, then you need to _re_-bodge to make
sure you're actually pointing at the actual Oracle installation you
want to use.

A


--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: Re: Trying to find miss and mister of the last month with highest rating
Next
From: Dave Coventry
Date:
Subject: Insufficient privileges.