Import oracle dump to PostgreSQL
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11650398/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Import oracle dump to PostgreSQL
提问by Gandalf StormCrow
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?
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).
What I though is to convert one dump (oracle) into another dump (postgres).
采纳答案by Craig Ringer
Check out ETL toolslike Talendand Pentahofor conversion between Oracle and PostgreSQL.
Check out ETL toolslike Talendand Pentahofor 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.
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.
回答by Matthias
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.:
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.:
回答by Shine
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.
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.
An alternative would be a migration tool, such as Talend, but again, it isn't immediate. The shortest path go through standard SQL, IMHO.
