22 January 2011

PostgreSQL - Migrating from Oracle to Postgres Using ora2pg

# tar xzf ora2pg-7.x.tar.gz
# cd ora2pg-7.x/
# perl Makefile.PL
# make && make install

# perl -MCPAN -e 'install DBI'

# export ORACLE_HOME
# export LD_LIBRARY_PATH=$ORACLE_HOME/lib
# perl -MCPAN -e 'install DBD::Oracle'

Edit /etc/ora2pg/ora2pg.conf to modify ORACLE_HOST ORACLE_USER ORACLE_PASSWORD
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Wordpress - Local installation in Vmware

If you're interested in exploring website design with WordPress, this guide will help you set up a WordPress instance on your local mach...

  • POSTGRESQL - Comparison between PostgreSQL vs EDB Postgres Advanced Server
    Your new IT project requires you to setup postgresql database and most of the time we get to the postgresql website and download the version...
  • LINUX - awk
    To print single column from a text file #awk -F: '{print $1}' /etc/passwd To print multiple columns from a text file # awk -F: '...
  • LINUX - netstat
    1. Using Netstat to Count TCP Connection States netstat -an|awk '/tcp/ {print $6}'|sort|uniq -c 2. List TCP/UDP and it's PID net...