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).

How was this "plain text" dump created? What form is it in?

DCookie
– DCookie

2012-07-25 14:11:23 +00:00
Commented Jul 25, 2012 at 14:11 — DCookie
– DCookie, Commented Jul 25, 2012 at 14:11
Probably it's better to ask dba.stackexchange.com

Luc M
– Luc M

2012-07-25 15:21:34 +00:00
Commented Jul 25, 2012 at 15:21 — Luc M
– Luc M, Commented Jul 25, 2012 at 15:21

Craig Ringer · Accepted Answer · 2012-07-25 13:47:52Z

2

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.

answered Jul 25, 2012 at 13:47

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shine · Accepted Answer · 2012-07-25 13:53:38Z

1

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.

answered Jul 25, 2012 at 13:53

Shine

3,8182 gold badges39 silver badges64 bronze badges

Comments

Matthias · Accepted Answer · 2016-03-04 14:59:23Z

1

With newer PostgreSQL versions (9.1 or later) you might be able to use a foreign data wrapper to access the Oracle schema from within your PostgreSQL database, e.g.:

http://laurenz.github.io/oracle_fdw/

answered Mar 4, 2016 at 14:59

Matthias

1781 silver badge9 bronze badges

Collectives™ on Stack Overflow

Import oracle dump to PostgreSQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related