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
