Re: db dump
Date: Fri, 15 Mar 2013 12:35:20 +0000
Message-ID: 1705317491-1363350919-cardhu_decombobulator_blackberry.rim.net-1133252711-_at_b28.c12.bise7.blackberry>
Best way as explained below is dump into text and copy, if you don't want any manual corrections after. Sent on my BlackBerry®
-----Original Message-----
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Sender: oracle-l-bounce_at_freelists.org
Date: Fri, 15 Mar 2013 13:33:23
To: <oracle-l_at_freelists.org>
Reply-To: thomas.kellerer_at_mgm-tp.com
Subject: Re: db dump
Jose Soares, 15.03.2013 11:54:
> I need to dump an oracle database to convert it to postgresql
> which is the easiest way to do that?
Check out Ora2Pg: http://ora2pg.darold.net/
It can migrate the schema definition (create table, create view, ...) and the data.
It won't get everything 100% right, but is a very good starting point.
Dumping the Oracle data to text files and then use COPY in Postgres is the best option to copy the data. Make sure you read the manual regarding what text format COPY expects.
Regards
Thomas
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 15 2013 - 13:35:20 CET