Fwd: Re: [ADMIN] migrating oracle table to PostgresQL - Mailing list pgsql-hackers

I believe this is one of the projects that we have slated for removal, since
it lives nicely elsewhere. Is it worth me writing up a patch to remove the
files and update the README to provide pointers to the project site and maybe
a few other places like the oraclecompat project (and maybe even
enterprisedb) or does someone with commit want to just go ahead and do it?

Robert Treat

----------  Forwarded Message  ----------

Subject: Re: [ADMIN] migrating oracle table to PostgresQL
Date: Thursday 29 December 2005 01:16
From: Gourish Singbal <gourish@gmail.com>
To: "Goulet, Dick" <DGoulet@vicr.com>
Cc: Bradley Kieser <brad@kieser.net>, Murugan G
<murugan.g@renaissance-it.com>, pgsql-admin@postgresql.org

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

-------------------------------------------------------



--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL