Re: Using ora2pg Perl Script

Doug Pisarek wrote:
> Trying to run ora2pg Perl Script. I would like to know what site I can
> go to get the perl modules to run this ora2pg script.
> I am receiving this error:
> perl ora2pg.pl
> Can't locate IO/Compress/Base/Common.pm in @INC (@INC contains:
> /oracle10g/OraHome1/perl/lib/site_perl/5.8.3/HTTP/Request
> /usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib
> /usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4
> /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int
> /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at
> /usr/perl5/site_perl/5.8.4/Compress/Zlib.pm line 11.
> BEGIN failed--compilation aborted at
> /usr/perl5/site_perl/5.8.4/Compress/Zlib.pm line 11.
> Compilation failed in require at Ora2Pg.pm line 429.
> BEGIN failed--compilation aborted at Ora2Pg.pm line 429.
> Compilation failed in require at ./ora2pg.pl line 12.
> BEGIN failed--compilation aborted at ./ora2pg.pl line 12.

What happens when you try 'cpan -h'?

At first glance I would say that if it can't find the base compression
modules then Perl wasn't installed correctly on that system. They are
core components. But you will need a Perl mailing list for help with
that. I would suggest looking at <http://www.perl.org/> for starters.

Bob McConnell
N2SPP