What you need is Ora2Pg, which is a Perl module that is used to export an Oracle database schema to a PostgreSQL-compatible...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
schema. It connects to your database, extracts the structure of the database and generates a SQL script that you can import into your Postgres database. It can dump the actual database schema (tables, views, sequences, indexes, grants), without editing the SQL code generated.
Ora2Pg is also capable of discharging the data in an online transaction, where one can choose what columns can be exported for each table. Features include database schema export (tables, views, sequences, indexes), grants/privileges export by user and group, data export and the SQL query converter. Best of all, the program is free and you can modify it under the same terms as Perl itself. Some more useful documentation on details of the process can be found here.
Dig Deeper on Linux servers
Related Q&A from Kenneth Milberg
Need a PaaS platform with strong production support? Explore production support and SLAs of AWS Elastic Beanstalk, IBM Bluemix, Google App Engine and...continue reading
When you move to PaaS for your web-based apps, remember to think about database services. Consider the benefits of moving your database to a fully ...continue reading
Making sure that your PaaS offering and the web development framework of your choice agree can be tricky. Learn how to choose the best framework for ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.