Oracle To PostgreSQL export(Centos)

■ EXPORT

 

#yum install perl-DBD-Pg perl perl-devel perl-DBI perl-CPAN -y
#yum install perl-Time-HiRes

#cd /data/ora2pg
#wget https://www.cpan.org/modules/by-module/DBI/DBI-1.642.tar.gz
#tar xvzf DBI-1.642.tar.gz
#cd DBI-1.642
#perl Makefile.PL
#make
#make install

#export ORACLE_HOME=/ora11g/product/11.2.0
#export LD_LIBRARY_PATH=/ora11g/product/11.2.0/lib

#perl -MCPAN -e shell

. . . . . .
Would you like me to configure as much as possible automatically? [yes]
. . . . . .
cpan[1]> get DBD::Oracle
. . . . . .
cpan[2]> quit

 

#cd ~/.cpan/build/DBD-Oracle-1.80-8ZKkdN/
#perl Makefile.PL
#make
#make install

#cd /data/ora2pg/
#rm -rf *
#wget https://cpan.metacpan.org/authors/id/T/TU/TURNSTEP/DBD-Pg-3.10.0.tar.gz
#tar xvzf DBD-Pg-3.10.0.tar.gz
#cd DBD-Pg-3.10.0
#perl Makefile.PL
#make
#make install

#cd /data/ora2pg/
#rm -rf *
#wget https://sourceforge.net/projects/ora2pg/files/20.0/ora2pg-20.0.tar.bz2
#bzip2 -d ora2pg-20.0.tar.bz2
#tar xvf ora2pg-20.0.tar
#cd ora2pg-20.0
#perl Makefile.PL
#make && make install

#cd /etc/ora2pg/
#cp ora2pg.conf.dist ora2pg.conf
#chown oracle:oinstall /etc/ora2pg/ora2pg.conf

#vi ora2pg.conf

ORACLE_DSN dbi:Oracle://ORACLE서버IP:1521/ORACLE인스턴스명
ORACLE_USER system
ORACLE_PWD oracle

이외 여러 파라미터들을 변경 할 수 있음

SCHEMA CN

 

스키마 export
oracle$ora2pg -d

 

데이타 export
oracle$ora2pg -t COPY -o data.sql -c /etc/ora2pg/ora2pg.conf