I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. But as an initial solution give it a shot.
Regards
From: casp <cesulbaran@gmail.com> To: pgsql-general@postgresql.org Cc: cesulbaran@gmail.com Sent: Thu, July 7, 2011 4:05:32 PM Subject: Re: [GENERAL] Oracle to Postgres migration open source tool
Good truth migration between Oracle and PostgreSQL are not things difficult: Indicates that your database has:
Tables: 20 Shema:? functions:? Views:?
They need help to migrate ... Or what are you suggestions if you need a tool that already does this task for you good people have a tool interprisedb postgres'm not recommending eye but no way they already have. : s
El jue, 07-07-2011 a las 09:55 -0400, akp geek escribió: > We have 20 tables in oracles that we needed to get to postgres -- ______________________________________ Ing. Cesar A. Sulbaran P. Junior Web Developer. (RUBY AND RUBY ON RAILS) User 100% Open Sources. Postgresql dba. Kernel: 2.6.32-5--bigmen http://www.google.com/profiles/cesulbaran