From: Jan Wieck <JanWieck@Yahoo.com>
To: Atul Pedgaonkar <atul@imcindia.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgresql To Oracle9i
Date: Wed, 05 Feb 2003 13:24:15 -0500
Message-ID: <3E4156CF.DEF6878B@Yahoo.com> (raw)
References: <OFENLAOAANCDIEKFLGOIOEDPCAAA.atul@imcindia.net>
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 #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, atul@imcindia.net
Subject: Re: Postgresql To Oracle9i
In-Reply-To: <3E4156CF.DEF6878B@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox