Fwd: Re: [ADMIN] migrating oracle table to PostgresQL

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(at)gmail(dot)com>
To: "Goulet, Dick" <DGoulet(at)vicr(dot)com>
Cc: Bradley Kieser <brad(at)kieser(dot)net>, Murugan G
<murugan(dot)g(at)renaissance-it(dot)com>, pgsql-admin(at)postgresql(dot)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(at)vicr(dot)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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)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