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.