Calling all Oracle/Postgres Database gurus!!

[brandonbull]

I'm working on a project and the source database is in a Postgres 8.3 environment and we are trying to move the data throught an Oracle gateway to build a reporting datamart in an Oracle 11 environment. The problem is the amount of time it takes to move the data. The Postgres and Oracle boxes have plenty of power and it's on a gigabit network. It's shouldn't take 9 hours to select a 500K record table from Postgres and build it in Oracle.

I don't know enough about Oracle and Postgres to even begin to troubleshoot the problem. Any suggestions would be helpful.