X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F049D9DC804 for ; Thu, 29 Dec 2005 02:16:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37517-07 for ; Thu, 29 Dec 2005 02:16:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.206]) by postgresql.org (Postfix) with ESMTP id 282E29DCA2B for ; Thu, 29 Dec 2005 02:16:51 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1752444nzn for ; Wed, 28 Dec 2005 22:16:52 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=NM7z9fYQTHk6doLAKH5hlUsIwtOVqjjqSvK0rpHZdAXI4X8e1XcHP8sUVNHVDKQgFJVahRFgIip6I7DcJesQlNUK+k6eVGPOr7+hrmbtyrcrce3UbHO6OyiJ4Ac4tSyeUEKiAZ4AKpHIMJ6r3bY1+z3sFXLcOm7wmGZvJsYruZI= Received: by 10.37.15.56 with SMTP id s56mr6336212nzi; Wed, 28 Dec 2005 22:16:52 -0800 (PST) Received: by 10.36.72.7 with HTTP; Wed, 28 Dec 2005 22:16:51 -0800 (PST) Message-ID: <674d1f8a0512282216o62a379c8obbd5fc8c6bc4aece@mail.gmail.com> Date: Thu, 29 Dec 2005 11:46:51 +0530 From: Gourish Singbal To: "Goulet, Dick" Subject: Re: migrating oracle table to PostgresQL Cc: Bradley Kieser , Murugan G , pgsql-admin@postgresql.org In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4470_2844356.1135837011962" References: <4001DEAF7DF9BD498B58B45051FBEA6502FEE979@25exch1.vicorpower.vicr.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.138 required=5 tests=[AWL=0.137, HTML_MESSAGE=0.001] X-Spam-Score: 0.138 X-Spam-Level: X-Archive-Number: 200512/360 X-Sequence-Number: 20080 ------=_Part_4470_2844356.1135837011962 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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 > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D > > 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=DCV 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_ > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D > > 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 ------=_Part_4470_2844356.1135837011962 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
ora2pg tool can be used to accomplish the migration from oracle to pos= tgresql. 
download it from here...
 
The one in contib directory is an old version i guess.
 
About clob, blob, and long columns in Oracle all become 'text' in post= gresql.
 
 
On 12/28/05, Goulet, Dick <DGoulet@vicr.com<= /a>> wrote:
As I browse through the contrib = directory I find an Oracle directory with example perl scripts to do just a= s your asking.

-----Original Message-----
From:
pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.o= rg ] 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 ta= ble to PostgresQL

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

PLSQL developer is also able to do a connection to both but is
c= ommercial software.

Alternatively, if you are really adventurous, se= t up a JDBC link to the
PG table via DBLINK in Oracle and then pump acro= ss that way.

Murugan G wrote:

> Hello,
> I have some tables cont= aining clob, blob, and long columns in Oracle,
> Is it possible to mi= grate these tables into PostgresQL along with data
>
> Thanks a= nd regards,
> G.Murugan,
> Sr. Software Engineer.
> Extn. 1658
&g= t; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D
> Sobha Renaissance Information Technology Private Limited
> An SEI-CMM & P-CMM Level 5 Company
> World's 1^st SSE-CMM Le= vel 5 Company
> BS 7799 certified by British Standards Institute
&= gt; ISO 9001:2000 Certified by T=DCV 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 _
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D
> The information transmitted is intended only for the p= erson or entity
> to which it is addressed and may contain confidenti= al and/or
> privileged material. Any review, retransmission, dissemination or<= br>> 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
&g= t; 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 c= olumn'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 mail= ing list cleanly



--
Best,
Gourish Si= ngbal=20 ------=_Part_4470_2844356.1135837011962--