Re: migrating oracle table to PostgresQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 
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@xxxxxxxx> 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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx ] On Behalf Of Bradley Kieser
Sent: Wednesday, December 28, 2005 10:12 AM
To: Murugan G
Cc: pgsql-admin@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx; 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@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly



--
Best,
Gourish Singbal

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux