Automating ODBC Import - postgresql to Oracle

[hotol]

Dear all,
I would like to copy the contents (tables) of a DB in postgresql to my Oracle DB. I have managed to manually do this via the ODB Import tool in PL/SQL Developer, which is fantastic. It was actually quick and easy.

So far so good, but I need to actually automate this procedure. So, here is the question: Has anyone else had to do this? What is the best way, etc.?

Most grateful for any help and tips

 

[Marco Kalter]

It cannot be automated in PL/SQL Developer.

 

[hotol]

Thanks, now I know. So, we will try another method.