very optimistic way
http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL
enterpriseDB
http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server
pdf howto for enterprise DB
http://www.pgcon.org/2011/schedule/attachments/205_Oracle_to_Postgres_Migration.pdf
detailed
http://get.enterprisedb.com/docs/Tutorial_All_Oracle_PPAS_Migration.pdf
postgres view to
http://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
orafce lib (http://pgfoundry.org/projects/orafce) - latest big release more then 2 years ago, need re-make of PG from source
ora2pg - perl script http://ora2pg.darold.net/ conversion of types, data migration
http://postgres-xc.sourceforge.net/
enterprise db video for migtation
compatibility
some tutorials
http://www.enterprisedb.com/resources-community/tutorials-quickstarts/all-platforms
http://www.enterprisedb.com/documentation/english
sony online saves money
http://www.enterprisedb.com/solutions/oracle-postgresql-business-case
postgres plus advanced (port - 5444)
superuser - enterprisedb, service account the same
xdb replication server
publication port - 9051
subscription port - 9052
replication server control db - edb
pgbouncer port - 6432
oracle
hr - qweasd
global comparison