On Thu, Jul 07, 2011 at 09:55:45AM -0400, akp geek wrote: > Hi all - > > Are there any open source tools available for migrating from > oracle to postgres. We have 20 tables in oracles that we needed to get to > postgres. Appreciate your help I have used ora2pg. It was not seamless -- I had to do some whacking around of the produced files, and I had a pretty good idea of what changes were needed in the ora2pg tool to improve things, but I didn't have time to implement them. It was still a lot easier than trying to do it all by hand. A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general