将oracle dump导入PostgreSQL

本文介绍了将oracle dump导入PostgreSQL的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个纯文本而不是oracle二进制转储.如何将其导入postgres?那里有可用的工具吗?还是还有其他的，有人曾经做过吗?

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?

我想将一个转储(oracle)转换为另一个转储(postgres).

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

推荐答案

查看 ETL工具(如塔伦(Talend)和 Pentaho 在Oracle和PostgreSQL之间进行转换.

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

从Oracle转储中将变得更加困难.几乎可以肯定，最好的选择是将其加载到Oracle实例中，然后从那里使用迁移/ETL工具.根据转储大小，所需的功能等，您可能可以为此使用免费的Oracle版本.

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.