dump data from postgreSQL to Oracle

This is something that I have never done before, so I am just posting the question here to see if I can get any feedbacks.

We have an existing project that is running by perl/cgi-bin, and postgreSQL is the backend DB server. And now we are trying to rewrite this project using java, and Oracle will be the backend db. We started the new one months ago, and now we need some real-time data to do some integration test. So the question is how to move some data in existing PostgreSQL table to Oracle table.

I never did such think before, the only way I can think of is to dump the data from PostgresSQL table to a file and have Oracle reads it ? But what happen there is schema change between either other, or some datatype mis-match, etc .. ?
I wand to know what is the Professional way to do such kind of work. Thanks.

cji Received on Tue Oct 03 2006 - 00:07:18 CDT