X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 96FBC475A80
	for <pgsql-sql@postgresql.org>; Wed,  5 Feb 2003 13:28:30 -0500 (EST)
Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com
 [216.136.173.59])
	by postgresql.org (Postfix) with SMTP id E8712475EE2
	for <pgsql-sql@postgresql.org>; Wed,  5 Feb 2003 13:26:11 -0500 (EST)
Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with
	plain)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 5 Feb 2003 18:26:10 -0000
Message-ID: <3E4156CF.DEF6878B@Yahoo.com>
Date: Wed, 05 Feb 2003 13:24:15 -0500
From: Jan Wieck <JanWieck@Yahoo.com>
Organization: Home
X-Mailer: Mozilla 4.8 [en] (Windows NT 5.0; U)
X-Accept-Language: en,ru
MIME-Version: 1.0
To: Atul Pedgaonkar <atul@imcindia.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgresql To Oracle9i
References: <OFENLAOAANCDIEKFLGOIOEDPCAAA.atul@imcindia.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/100
X-Sequence-Number: 11498

Atul Pedgaonkar wrote:
> 
> Hello,
> 
>         Atul here From india.Anyone who knows how to mirgrate the data from
> postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the
> data.

Use pg_dump to create separate schema and data (as INSERT statements)
dumps. Edit the schema so that Oracle is happy with it and run the two
SQL scripts.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #