Skip site navigation (1) Skip section navigation (2)

Re: importing an Oracle database into Postgres

From: Matthew Hixson <hixson(at)poindextrose(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: importing an Oracle database into Postgres
Date: 2005-12-29 00:11:44
Message-ID: CEC8CE15-CB4D-400B-A114-082434187244@poindextrose.org (view raw or flat)
Thread:
Lists: pgsql-general
Hi David, it looks to me like this tool makes an external data source  
appear to live within Postgres.  What I want to do is dump an Oracle  
database and replace it with Postgres.  From that point on I don't  
ever want to see Oracle again.  Can your software be used to  
accomplish that goal?
   Thanks,
    -M@

On Dec 28, 2005, at 1:10 PM, David Fetter wrote:

> On Wed, Dec 28, 2005 at 12:12:06PM -0800, Matthew Hixson wrote:
>> What's the best way to import an Oracle database into Postgres?  I'm
>> using Oracle 8.1 and Postgres 8.1.1.
>
> DBI-Link. http://pgfoundry.org/projects/dbi-link/
>
> Let me know if you have questions or problems along the way :)
>
> Cheers,
> D
> -- 
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 415 235 3778
>
> Remember to vote!
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


In response to

pgsql-general by date

Next:From: Ted ByersDate: 2005-12-29 00:14:41
Subject: Re: Final stored procedure question, for now anyway
Previous:From: Trent ShipleyDate: 2005-12-29 00:03:07
Subject: Re: WAL logs multiplexing?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group