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

Re: migrating oracle table to PostgresQL

From: "Goulet, Dick" <DGoulet(at)vicr(dot)com>
To: "Bradley Kieser" <brad(at)kieser(dot)net>,"Murugan G" <murugan(dot)g(at)renaissance-it(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: migrating oracle table to PostgresQL
Date: 2005-12-28 15:26:22
Message-ID: 4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com (view raw or flat)
Thread:
Lists: pgsql-admin
As I browse through the contrib directory I find an Oracle directory with example perl scripts to do just as your asking. 

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Bradley Kieser
Sent: Wednesday, December 28, 2005 10:12 AM
To: Murugan G
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] migrating oracle table to PostgresQL

Yes.
But Oracle is completely useless at dumping data. You may want to use 
the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to 
connect both to Oracle and PG.

PLSQL developer is also able to do a connection to both but is 
commercial software.

Alternatively, if you are really adventurous, set up a JDBC link to the 
PG table via DBLINK in Oracle and then pump across that way.

Murugan G wrote:

> Hello,
> I have some tables containing clob, blob, and long columns in Oracle, 
> Is it possible to migrate these tables into PostgresQL along with data 
>
> Thanks and regards,
> G.Murugan,
> Sr. Software Engineer.
> Extn. 1658
> ===========================================================================
> Sobha Renaissance Information Technology Private Limited
> An SEI-CMM & P-CMM Level 5 Company
> World's 1^st SSE-CMM Level 5 Company
> BS 7799 certified by British Standards Institute
> ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
> A Six Sigma Practice Company
> Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 
> 80 51252222
> Email : murugan(dot)g(at)renaissance-it(dot)com; Web:_ www.renaissance-it.com_
> ===========================================================================
> The information transmitted is intended only for the person or entity 
> to which it is addressed and may contain confidential and/or 
> privileged material. Any review, retransmission, dissemination or 
> other use of, or taking of any action in reliance upon, this 
> information by persons or entities other than the intended recipient 
> is prohibited. If you received this in error, please contact the 
> sender and delete all copies from any computer.
>
>

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2005-12-28 15:33:08
Subject: Re: Help with simple function
Previous:From: Bradley KieserDate: 2005-12-28 15:12:23
Subject: Re: migrating oracle table to PostgresQL

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