pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gourish Singbal <gourish@gmail.com>
To: Goulet, Dick <DGoulet@vicr.com>
Cc: Bradley Kieser <brad@kieser.net>
Cc: Murugan G <murugan.g@renaissance-it.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: migrating oracle table to PostgresQL
Date: Thu, 29 Dec 2005 11:46:51 +0530
Message-ID: <674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com> (raw)
In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com>
References: <4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com>

ora2pg tool can be used to accomplish the migration from oracle to
postgresql.
download it from here...
http://freshmeat.net/projects/ora2pg/

The one in contib directory is an old version i guess.

About clob, blob, and long columns in Oracle all become 'text' in
postgresql.


On 12/28/05, Goulet, Dick <DGoulet@vicr.com> wrote:
>
> 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@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] On Behalf Of Bradley Kieser
> Sent: Wednesday, December 28, 2005 10:12 AM
> To: Murugan G
> Cc: pgsql-admin@postgresql.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.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.
> >
> >
>
> ---------------------------(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>



--
Best,
Gourish Singbal

view thread (5+ messages)  latest in thread

Message-ID: <674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com>
Permalink:  ../674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com/
Also on:    postgresql.org/message-id/674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com

 · 

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: gourish@gmail.com, DGoulet@vicr.com, brad@kieser.net, murugan.g@renaissance-it.com
  Subject: Re: migrating oracle table to PostgresQL
  In-Reply-To: <674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com>
  References: <4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com> <674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com>

* 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