Re: db dump

From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 15 Mar 2013 13:33:23 +0100

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


--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: db dump
  - From: rajugaru . vij

References:
- db dump
  - From: Jose Soares

Re: db dump

Other related posts: