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 3326B9DCA27 for ; Wed, 28 Dec 2005 11:12:10 -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 87482-01 for ; Wed, 28 Dec 2005 11:12:12 -0400 (AST) X-Greylist: delayed 05:15:50.030292 by SQLgrey- Received: from laptop.kieser.net (kieser2.demon.co.uk [80.176.229.121]) by postgresql.org (Postfix) with ESMTP id BFC379DC9DF for ; Wed, 28 Dec 2005 11:12:05 -0400 (AST) Received: from [127.0.0.1] (laptop.kieser2.demon.co.uk [127.0.0.1]) by laptop.kieser.net (Postfix) with ESMTP id BB7EEC1A81; Wed, 28 Dec 2005 15:12:23 +0000 (GMT) Message-ID: <43B2AB57.4070502@kieser.net> Date: Wed, 28 Dec 2005 15:12:23 +0000 From: Bradley Kieser User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Murugan G Cc: pgsql-admin@postgresql.org Subject: Re: migrating oracle table to PostgresQL References: <038D31443AEF2040BC33D56D85DFD49A011AE731@sobha_mail.renaissance-it.com> In-Reply-To: <038D31443AEF2040BC33D56D85DFD49A011AE731@sobha_mail.renaissance-it.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.359 required=5 tests=[AWL=-0.120, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.359 X-Spam-Level: X-Archive-Number: 200512/343 X-Sequence-Number: 20063 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. > >