Import oracle dump to PostgreSQL

Question

I have a plain text not oracle binary dump. How can I import this to postgres? Are there tools available for this out there? Or is there some other one, anyone did this before?

What I though is to convert one dump (oracle) into another dump (postgres).

Answer 1

Check out ETL tools like Talend and Pentaho for conversion between Oracle and PostgreSQL.

From an Oracle dump it's going to be much more difficult. Your best bet is almost certainly to load it into an Oracle instance and then use migration/ETL tools from there. Depending on the dump size, features required, etc, you might be able to use a free Oracle version for this.

Answer 2

I don't think it is feasible in an easy immediate way. Is the plain text in sqlloader format? I think it may be easier for you, if the database size isn't huge, to export DDL and then data in INSERT format.

An alternative would be a migration tool, such as Talend, but again, it isn't immediate. The shortest path go through standard SQL, IMHO.