I'll walk you through all the problems and difficulties that can occur when you migrate an Oracle database to PostgreSQL, from the conceptual phase and general architectural differences to the specific problems that you are likely to encounter. I'll suggest solutions or promising ways to tackle these problems and give you a brief overview over some of the existing tools that facilitate Oracle migration.