将oracle dump导入PostgreSQL [英] Import oracle dump to 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)和

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.

这篇关于将oracle dump导入PostgreSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！