Installing Ora2Pg

Installing Ora2Pg

Like any other Perl Module, Ora2Pg can be installed with the following commands:

tar xjf ora2pg-x.x.tar.bz2
cd ora2pg-x.x/
perl Makefile.PL
make && make install

This will install Ora2Pg.pm into your site Perl repository, ora2pg into /usr/local/bin/ and ora2pg.conf into /etc/ora2pg/.

On Windows(TM), you may use instead:

perl Makefile.PL
gmake && gmake install

This will install scripts and libraries into your Perl site installation directory and the ora2pg.conf file as well as all documentation files into C:\ora2pg\

To install ora2pg in a different directory than the default one, simply use this command:

perl Makefile.PL PREFIX=<your_install_dir>
make && make install

then set PERL5LIB to the path to your installation directory before using Ora2Pg.

export PERL5LIB=<your_install_dir>
ora2pg -c config/ora2pg.conf -t TABLE -b outdir/