pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bradley Kieser <brad@kieser.net>
To: Murugan G <murugan.g@renaissance-it.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: migrating oracle table to PostgresQL
Date: Wed, 28 Dec 2005 15:12:23 +0000
Message-ID: <43B2AB57.4070502@kieser.net> (raw)
In-Reply-To: <038D31443AEF2040BC33D56D85DFD49A011AE731@sobha_mail.renaissance-it.com>
References: <038D31443AEF2040BC33D56D85DFD49A011AE731@sobha_mail.renaissance-it.com>

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.g@renaissance-it.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.
>
>



view thread (5+ messages)  latest in thread

Message-ID: <43B2AB57.4070502@kieser.net>
Permalink:  ../43B2AB57.4070502@kieser.net/
Also on:    postgresql.org/message-id/43B2AB57.4070502@kieser.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: brad@kieser.net, murugan.g@renaissance-it.com
  Subject: Re: migrating oracle table to PostgresQL
  In-Reply-To: <43B2AB57.4070502@kieser.net>
  References: <038D31443AEF2040BC33D56D85DFD49A011AE731@sobha_mail.renaissance-it.com> <43B2AB57.4070502@kieser.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox