This content has been marked as final. Show 2 replies
Porting Oracle SQL to postgre SQL is a complex one. as u said there are lot of structural changes needed to be done.
Here is the link that gives u some ideas.
U gonna try with Migration or replication ?
May be golden gate is help to replicate oracle to postgreSQL.
But goldengate also have lot oflimitations.Check the bellow link tofind that.
you use ant ETL tool like Talend or Pentaho Kettle solution...